Table INReceiptStatus and INCostStatus will work to obtain the receipt number used in a sales order?

Question

Hi!I need to track the receipt number of an item that was selected for a sale. This means, track the receipt number related to an item that was submitted in a sales order/invoice.In this post, the logic for table The logic behind Table INReceiptStatus and INCostStatus | Community (acumatica.com) was explained. So, Im thinking that this could help me to track it but Im guessing that there is another table intermediary between the purchase and the sales.Does someone know which table could be? Thanks.

Yuriy Zaletskyy · Accepted Answer

Based on the information provided, it sounds like the INReceiptStatus table is the most appropriate table to use to track the receipt number of an item that was selected for a sale. This table contains receipt number and receipt date information for every inventory receipt/return.

If you need to track the connection between a purchase and a sale, you may consider using the POOrder and SOOrder tables. The POOrder table contains information about purchase orders, and the SOOrder table contains information about sales orders. You can use the ReceiptNbr field from the INReceiptStatus table to link an inventory receipt to a purchase order in the POOrder table, and then use the OrderNbr field from the POOrder table to link the purchase order to a sales order in the SOOrder table.

It is important to note that this is just one approach, and you may need to make modifications to suit your specific use case.

rodrigocid34 · Answer

Thank you Yuri,Im going to look into it. Just fyi...Im not trying to obtain the ReceiptNbr in a Sales to Purchase case, i want to obtain it when FIFO or serial issues method are performed.Ill update this case after testing.

Table INReceiptStatus and INCostStatus will work to obtain the receipt number used in a sales order?

2 replies

Reply

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded