M
meangene
I am trying to create a delimited file for use by my ERP import tool that
will show item adjustment detail in the correct format for the ERP. Example:
Have a FIFO tier table with an item with two tiers:
Item Date Qty
ABC 1/1/08 13
ABC 2/12/08 100 (Total QtyOnHand: 113)
I have another table (Item_Adj) with a single record adjusting -40
Adj Item Adj Qty
ABC -40
Need to create two records for my ERP from the above where I end up with
following in another table (Adjustment Qty):
Item QtyAdj
ABC -13
ABC -27
Can this be done with a make table or combo of make table/update?
will show item adjustment detail in the correct format for the ERP. Example:
Have a FIFO tier table with an item with two tiers:
Item Date Qty
ABC 1/1/08 13
ABC 2/12/08 100 (Total QtyOnHand: 113)
I have another table (Item_Adj) with a single record adjusting -40
Adj Item Adj Qty
ABC -40
Need to create two records for my ERP from the above where I end up with
following in another table (Adjustment Qty):
Item QtyAdj
ABC -13
ABC -27
Can this be done with a make table or combo of make table/update?