Skip to main content
Solved

Supplying Inventory Balances For Testing Purposes


Forum|alt.badge.img+5

Does anyone have thoughts on how I might supply inventory balances to the system externally without having to manage inflows (Purchase Receipts) and outflows (selling stock from the warehouse)?

As we test transitioning from our old system, we’d like to use the balances from the old system but allow the new system to enforce order limits, etc.

I’m guessing this is not a thing, but I’m curious if anyone has any clever tricks to make this work...

Best answer by Kandy Beatty

rosenjon wrote:

@kbeatty21 I can do that. However, how do I synchronize the balance with the external system? What happens when a certain item gets sold in the external system and inventory is reduced by 10? Would I have to trigger the sale in Acumatica? I’m trying to do something where I can just flip a single number and that’s the new inventory balance...

In this case, I believe the Inventory Receipt is your best option. You can create one receipt with many lines and possibly do that once a day. 

View original
Did this topic help you find an answer to your question?

5 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • March 10, 2022

Hi @rosenjon 

What about Inventory Receipts? I know you can use those to bring in balances. 

You could also do an import scenario to bring them in as well. 


Forum|alt.badge.img+5
  • Author
  • Semi-Pro III
  • 293 replies
  • March 10, 2022

@kbeatty21 I can do that. However, how do I synchronize the balance with the external system? What happens when a certain item gets sold in the external system and inventory is reduced by 10? Would I have to trigger the sale in Acumatica? I’m trying to do something where I can just flip a single number and that’s the new inventory balance...


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • March 10, 2022

@rosenjon 

What is the external system? Are you using a connector between Acumatica and an eCommerce platform?


Forum|alt.badge.img+5
  • Author
  • Semi-Pro III
  • 293 replies
  • March 10, 2022

No it’s just our legacy ERP system. We push the data out programmatically and use the REST APIs in Acumatica to push it in.


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • Answer
  • March 10, 2022
rosenjon wrote:

@kbeatty21 I can do that. However, how do I synchronize the balance with the external system? What happens when a certain item gets sold in the external system and inventory is reduced by 10? Would I have to trigger the sale in Acumatica? I’m trying to do something where I can just flip a single number and that’s the new inventory balance...

In this case, I believe the Inventory Receipt is your best option. You can create one receipt with many lines and possibly do that once a day. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings