Solved

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

  • 2 February 2023
  • 2 replies
  • 82 views

Userlevel 4
Badge

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.

icon

Best answer by Yuriy Zaletskyy 4 February 2023, 22:59

View original

2 replies

Userlevel 5
Badge +3

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.

Userlevel 4
Badge

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.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved