Questions
I am facing a problem with the Item Fulfilment Saved search. I have noticed that the Mainline filter of Item fulfillment type transaction
search is wrong. If I set the mainline as false in the filter I am getting the item listed in the result as one line missing from the result, which is the first item line of item fulfillment
I have attached the screenshot of the issue I am facing.
The Image of item fulfillment is given below. I have put this internal ID as criteria for the saved search. The item fulfillment contains 4 items that come under the item type of Assembly/Bill of Materials or Inventory Item.
The search criteria and results are given below, I have put the mainline as false still. it shows only 3 items but there was actually 4 items in item fulfillment. I was expecting a result with four lines. The very first item in IF is missing from the search. Is there a solution or explanation for this?
Answers
Item Fulfillments are strange (Like transfer orders and journals). For Item Fulfillments, Line Zero (Mainline) also includes an item being
fulfilled. You will also see 3 lines for each item fulfilled when you have no other filters in criteria.
To get detail, do not specify Mainline.
Actually, once you see the data it really makes sense.
For orders/invoices/PO’s and bills, Mainline refers to the custom/vendor, the order level data. Yes, there is that type of data on a
fulfillment (sort of) but it is more about what inventory was moved out of the location and at what cost (COGS)
To get what you normally think of as Main Line = NO, just do not specify Mainline at all.
And since there are 3 lines per Sales Order line being fulfilled, I use the joined Account table (field=Type) to get what I am going after (if
COGS or Asset) or account is NULL
if Account = NULL, similar to standard Mainline=No
Account Type = COGS – This is the Extended Cost at the time the fulfillment happened. The Debit to the COGS account
Account Type = Asset – This is the Credit to the Inventory account
My guess is that it was designed this way as you can only specify 1 GL account per transaction line.