Sunday, 26 August 2007

Post Sales Shipment

What Navision will do behind the scene when you Post Shipment from Sales Order ?
  1. Navision will first update the Last No. Used and Last Date Used in the No. Series Line table.
  2. Next is to update the Shipping No. and Ship fields in Sales Header table. Ship field will be updated to Yes.
  3. Navision will then update the Amount, Amount Including VAT and VAT Base Amount fields in Sales Line. Amount and Amount Including VAT are internal fields used by Navision. From what I observerd, the value in the Amount field and VAT Base Amount do not include VAT. Therefore, Amount and VAT Base Amount fields have the same value while the Amount Including VAT field has higher value than the other two fields.
  4. Navision will update the WHT Absorb Base field. WHT stand for Withholding Tax. I am not sure what is the purpose of this field as my company is not using it.
  5. Then, Navision will insert a new record into the Sales Shipment Header table to create a new Sales Shipment.
  6. Navision will delete all Address ID records that are related to the newly craeted Sales Shipment Header record. Frankly, I am not sure what is the purpose of Address ID table. From my test data, this table is always empty. However, Navision will issue a delete statement against this table. I will update this section again when I know what is the purpose of the Address ID table.
  7. Navision will then insert a new record into the Item Application Entry table.
  8. Next is to update the Remaining Quantity field in the Item Ledger Entry table in the inbound (positive) entry to reflect the latest remaining quantity. The new remaining quantity is the existing remaining quantity minus the quantity shipped. Applied Entry to Adjust field is set to true. This indicates that there is one or more applied entries need to be adjusted.
  9. Insert a negative Quantity record into the Item Ledger Entry table with Entry Type = Sales, Source No. = Customer No. and Source Type = Customer Number. Quantity field will store negative value of the quantity shipped. Cost Amount (Expected) will store the negative value of the Cost for the items shipped. Please note that Cost Amount (Expected) is a flowfield from Value Entry table.
  10. Insert an Item Register record for the Item Ledger Entry record created.
  11. Insert a Value Entry record for the Item Ledger Entry created. The Expected Cost field is set to True to indicate this value entry has not been invoiced yet. Therefore, the value was posted as expected cost. The Sales Amount (Expected) will be updated with a positive value of the sales amount. The expected cost will be updated to the Cost Expected (Amount) field with a negative value. As the name implies, both sales amount and cost are expected value because the items are not invoiced yet. Both fields will be will be reference by flowfields in Item Ledger Entry table.
  12. Set Cost is Adjusted field and Allow Online Adjustment fields in the Item table to No. This indicates that the Item's cost has not been adjusted yet. The Cost is Adjusted field will set to Yes if the Item's cost has been adjusted.
  13. Update the From Value Entry No. and To Value Entry No. field in the Item Register table for the Item Register record created in step 10.
  14. Create a Sales Shipment Line record.
  15. Update the Sales Header record with Shipping No. set to empty and the Last Shipping No. field with the last posted sales shipment number used. Navision will use the next number from the number series setup when you want to post shipment again because Shipping No. field has been emptied. If the Shipping No. field is not emptied, Navision will try to use back the same shipping number when you do post shipment for this sales order. This will cause Navision to throw an error because the shipping number has been used. Therefore, this field must be emptied after each post shipment. But there is a bug in Navision which sometime caused this field not emptied after post shipment. If this error occured, you can simply delete the value in the Shipping No. field from the database level.
  16. Update Outstanding Qty, Qty. to Invoice, Outstanding Amount, Qty. Shipped Not Invoiced, Shipped Not Invoiced, Quantity Shipped,.....etc in the Sales Line table.
  17. Insert a new record into Item Analysis View Entry table
  18. Finally, insert a new record into Item Analysis View table.


Unknown said...

Hi I tried to delete a sales invoice in Navision, but it said do you want to delete sales header record. I said yes , how can I reverse that please help.

Admin said...

There is no way to reverse deletion.

Unknown said...

Could you please tell me how do I get back a deleted sales header record?

Unknown said...

Thanks, oh dear !!!! The info is still in the general ledger entries. I need to reissue the invoices what should I do pls :0.