Inventory, Orders Management, Warehouse Operations
- 848 Topics
- 3,201 Replies
HELP!! Error An error occurred during processing of the field PaymentMethodID: Error: An error occurred during processing of the field Last Modified On: Specified cast is not valid...
Any help would be greatly appreciated!I cannot prepare invoices AT ALL! I am not sure what changed but if anyone has any idea how to get this fixed i would really appreciate it, need this fixed asap :( Thanks!
Hi!Let’s picture a scenario where a Retail Company sells shoes through 45 stores and They have the next environment in each store:POS software with an interface to Dynamics GP POS software update GP in real time, it means, when a sell is being made in a store, the POS use the GL accounts defined on the item to post in GP the invoice process (inventory, ar invoice accounts) and in the same transaction, the payment is registered too (Post in GP the Payment accounts such as sales account, bank account, etc).With that said, let’s say that in december they process 200k transactions. The 200k transactions are related to the POS process described above.My question is, 200k transactions are considered ERP transactions instead or Commercial Transactions?Thanks!
The scenario:The company has one large warehouse in the UK and two smaller ones in The Netherlands and Dubai.They supply the other two warehouses from a weekly container shipment.Preparation of the container shipment takes a few days and it is only on the last day when the final goods are loaded in. The Acumatica transfer order is not ideal as a shipment needs to be created before the goods can be picked. Additions require an additional shipment. What seems to be the better option is to create a location in the warehouse called something like “NLD Transfer” where the users can create 1 step inventory transfers during the week. That is the easy part. The next one is the ability to create one Sales Order transfer document for the complete contents of the “NLD Transfer” location.A GI export of the items and quantities into a transfer order will work but is there any other way?Thanks James
I would like to ask is it possible and how to set outside process (outsourcing) without manufacturing mode. Till now I found solutions only for manufacturers by creating Production Orders but what if there is no production onside and we ship a purchased item to the Vendor for an outside process (coating etc) and then afterwards we receive it back from Vendor ready to sell. How to organize that case in the system in order to calculate costs correctly and track the item?
For example, warn the users that there are open purchase orders when you change the status to No Purchases. Procedurely, users should use the Inventory Summary or Allocation Details before changing the status but a warning would be a good idea.
We have a customer that requires the use of data matrix barcodes containing multiple pieces of data (Item barcode and serial number). The Acumatica WMS will read this type of 2D barcode, but we are not able to print them in order to label items.What solutions or ISVs are available to allow us to print the product labels?
Hi!I am working on figuring out how to make the following happen…I need to be able to have a map that assigns a sales person to the sales order depending on the customer account and which warehouse the product is coming from. Anyone have any ideas on how to make that happen? Any help or input would be greatly appreciated :)Thank you!
I am seeking any feedback from those who have successfully or unsuccessfully used the ShipEngine shipping solution for Acumatica.We have tried the ShipStation integration and found its functionality limited (especially with international orders) and found their support lacking.We are now considering the ShipEngine solution.If you have used it, I am very interested in hearing how it is working for you and how it compares to other shipping solutions you have tried.
Hello!I wanted to outline an issue we’re having with Availability calculations and how to account for high volume SOs that require future stock for fulfillment. Hopefully other companies have experienced this problem and may have some good ideas.Let’s say we have 1,000 units of SKU X on hand and available in our domestic warehouse. We also have 20,000 units of SKU X on PO at one of our vendors. We don’t currently include Qty on PO in our availability calculation because it can take 60+ days to ship POs and 30+ days of transit time.A big wholesale customer places an SO for 5,000 units of SKU X, with the plan to have this fulfilled sometime in the future after the 20,000 units arrive. Right now, this type of situation drops our Qty Available down to -4,000 and it’s confusing to other sales reps whether there is any inventory to sell. Indeed, there is actually 1,000 units still available to sell.Ideas we’ve thought of:Linking this SO line to the pre-existing PO line. This resolves the Qty
I have installed the shipping carrier integration with an easypost account. I created a SO, confirmed the shipment and get a tracking number. My question is, the only way to track the shipment is using the external Easypost web page?There is no inquiry or report with the same informatin within Acumatica? I just want to confirm how will be the user experience to a customer for tracking their shipments.
Hello, I believe I know the answer to this question but I wanted to confirm as I am still just learning the system. Is there a way to create a mass 1 step transfer for multiple items on different dates? All of these will be going from and to the same locations so only the dates for the transfer would be different. Seeing as the date is in the document header for a 1 step transfer I am thinking I cannot do an upload with all of the transfers on separate dates but I wanted to confirm. Thanks,
Hello, In 2020r2, we’ve had a new feature called “intercompany sales”.https://help-2020r2.acumatica.com/Wiki/(W(2))/ShowWiki.aspx?pageid=e4827607-362f-40fb-b466-303c414ee980 According to the guide, it says it can deal with “sold goods” scenario. Unfortunately, according to my understanding, it is not. Both AR invoice and AP bill has nothing to do with Inventory. For real intercompany goods sold, the inventory of company A which pretends to be the vendor should have qty deduction, while the company B which to be the customer should have qty increasing. And in most cases, we do real shipment. We ship goods from company A to company B. Company A do real shipment, company B do real receiving. The new feature did not take this into consideration. So in short, can we request for a full feature of “intercompany sales”, which we can extend the PO to a SO?
Hello, apologies for the long question.I am working to setup Acumatica and noticed the handling of inventory for Sales Order shipments is different than every system I have worked on in the past. With our current configuration, when you create shipment for a Sales order you stop just short of Updating IN. This is because one you Update IN it creates the inventory COGS transaction on the PL. We do not invoice and recognize the revenue, until the product is delivered to our customers. So if you do Update IN this creates a disconnect between revenue and expense (not an option). However, if you do not Update IN the inventory remains “On Hand” at the warehouse and all reporting shows those quantities on hand. What I would prefer to see is that inventory moved to In Transit until the SO is invoices at which time the inventory is expenses and the Receivable is created. Due to the inventory remaining ON Hand I am having a difficult time reconciling physical counts at our sites and creates a hu
Hi guys,I want to tracking serial number for some high value item. I enabled Lot and Serial Tracking feature. I created a Serial class and used on an item. Than I tried to follow below manual to test it but there is no separate line let me scan serial number. Does any know what’s going on with this?https://help-2020r2.acumatica.com/(W(5))/Help?ScreenId=ShowWiki&pageid=8a849d2b-0a55-467f-b537-28bc6e192de3
Is there a way to recalculate the margin of a stock item sold, to take into account a cost adjustment recorded after the sale, but which relates to a receipt prior to the sale ?Example :02/01/2021: purchase receipt of the article with a cost of 100 USD02/01/2021: billing of the purchase receipt with the same cost02/02/2021 : sale of the stock item for a price of 130 USD => margin equal to 30 USD02/03/2021 : landed cost of 10 USD related to the purchase receiptI would like the margin of my sale to be recalculated to 20 USD. Is it possible ?
What's the difference/purpose "Include in Qty. Available" and "Sales Allowed" for Warehouse Locations
We’re finally starting to get a handle on Availability and Alloctions...I think We have a DEMO location with items we do not want included for normal Sales operations, but do occasionally ship to customers or distributors. Unchecking the “Include in Qty. Available” is a necessity since we do not want these items to be considered as available for normal Sales Orders. However, with “Sales Allowed” still checked, we can add the items from that location to a Sales Order, but we cannot create a Shipment. The documentation says this:Include in Qty. Available A check box that you select if the quantities of goods available at this location will be included in the quantities of available goods and used in shipments and transfers. Sales Allowed A check box that you select if only issues (direct inventory issues as well as the issues generated from sales orders) are allowed for the location. You clear the check box if no inventory transactions are allowed for this location, except for i
Hi!I run a report for our sales team every week that includes the following: The problem with this report is that the column “OrderStatus” gives me that status of the sales order, when i really need the status of the sales order line. Ex: The sales order has 5 lines on it, 4 of the 5 lines are shipping but the one that is not shipping shows up on the report with a status of “shipping” because the status of the sales order is shipping but the line is not. Is there anyway to get a line status put in there?
I have been working on a business event that triggers an email once a customer creates order from the web portal and falling short. The trigger has not worked if the portal users generate the order. If I change the business event to trigger on record change and then do any modification changes from the ERP side, it works from the portal sales orders. The New field value is set to createdByScreenID and Screen ID = SP700001. Could this be related to the customer's user's account types and users' permissions? Your support is appreciated.
Hello Guys; Hope you’re doing Well I have a problem when releasing one invoice:I get the error message “another process has added to InRegsiter”I’ve cheked the Issues List and there is nothing with the the shipping Number of the Invoice Any ideas ? Thank you :)
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.