| Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-275550 - Update customer. live to the most current version of 19.1|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-275550]
*This issue relates to i21 Help Desk ticket:* [ HDTN-274426 - INVENTOY/GENERAL LEDGER QUESTIONS|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-274426]
+Steps:+
# From Inventory > Items, create/duplicate 2 raw items and 1 finished goods item.
# From Inventory > Items, create a Recipe using the 2 raw items as Input item and the finished goods as the output item.
# Enter other details, select Process as Blending then click Save.
# From Transports > Transport Loads > New, enter the details for Receipts, Distribution Header and Detail.
# Click Save and Post.
# Go to Inventory > Inventory Valuation and check the details, specifically the costing method and quantities.
+Issue:+
* Incorrect costing method is used for sales invoice generated from transport loads.
+Acceptance:+
* Should show and use the correct costing method for sales invoice generated from transport loads.
+Additional Details+
I have a couple of questions concerning inventory posting to general ledger/financial statements.
We transfer fuel from our bulk plant sometimes for sale to a transport customer. Before I go on I should tell you I have the button checked in the inventory item to allow negative sales. I am enclosing a copy of the general ledger detail for the cost of goods on B11LSC. It looks like I am getting cost of goods from the transfer and then again from the sales invoice. This is shorting our gross profit on this inventory item for the month by about $15000. This instance does happen several times during the month. Is it happening because of the negative inventory? I don't know why we would ever have negative inventory here because this location does not have inventory. We get the product in and then sell it out in the same TR.
The second problem I have is an inventory adjustment. ADJ-1466 I adjusted the Alcohol inventory by -25.2995 gallons and the cost of goods on this product says it was adjusted by 5024.75 gallons. Big difference. I have attached copies of both reports.
Both are messing up the financial statements.
SEE ATTACHMENTS.
|