Inventory, Orders Management, Warehouse Operations
- 702 Topics
- 2,498 Replies
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
Hello I'm attempting to create a single import scenario on InventoryItem attributes to update any item attributes without overriding the existing data. When running an import scenario with item InventoryItem attributes, if a field is empty on the import source sheet, then on import, it will override the data in the destination in that field and make it blank. I tested in the mapping sections using ISNULL([WILDLIFE],[Answers.Value]) in the Source field/Value, and had success. The issue I face is attributes that are checkboxes. The date gets imported as "False". I tried various IIF statements, with and without converting the data to different data types, and still no success.
We need help with how to book purchase discount in the following two situations:Suppliers will offer a 25% (for example) discount if we agree to take a large amount of product. We want to book this special discount as “purchase discount”. How do we do it. Suppliers will offer us a 50% discount on freight charges if we pay the product invoice within X days. We want to book this 50% freight discount as purchase discount. How do we do it? (We use landed cost to compute cost.)Your suggestions are greatly appreciated.
We are running 2019R2.I can successfully release a worksheet of sales prices that are setup as customer specific pricing with an alternate ID specified:But when I lookup the pricing on Sales Prices screen, it does not show the Alternate ID:On the Stock Items screen, under Cross Reference tab, it does not show as Customer pricing, but as Global (without the customer number):Oddly enough, when processing sales orders, the alternate ID can be used for any customer and it will find the corresponding stock item number (not what we wanted). BUT it will only assign the price for the customer that was specified when the price was loaded via the worksheet. So the pricing aspect of this is still working. So my questions are:Why doesn’t Sales Price screen show the alternate IDs? How do I fix this? What is causing the Stock Items screen-Cross Reference tab to tag this as Global instead of customer specific pricing? How do I fix this?Thanks.
Acumatica Distribution Edition WebinarMarch 17, 2021 11:00 am - 11:30 am PSTJoin us for a 30-minute webinar where you will hear an overview of Acumatica Distribution Edition and discover real-time visibility into sales, order management, inventory, purchasing, production and services—and accounting information. In addition, discover new Acumatica 2021 R1 features.REGISTER NOWDistribution Webinar March 17, 2021
Hi Everyone!Does anyone know of a way to assign sales reps in Acumatica based on item class and customer/business account at the time of sales order entry?Example: IF item class = Consignment, THEN Sales Rep = Business Account OwnerAny help would be greatly appreciated :)Thank you!
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!
Is there an option that would allow a stock item to be added to or removed from an existing template ID? Example, an existing item is purchased from the manufacturer today with only one size and one color. However, the following year they update the product to include multiple sizes and color. We want to retain the history with the original size and color, but then add that item to a template item which includes the additional sizes and colors. I thought there was an option/configuration to allow the editing of template ID on an item, but can’t seem to find it. Anyone know if that functionality exists?
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!
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.
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.
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!
Hello,I am currently using template items and I created 4 matrix items from it.There are transactions on those items, but we would want to change the Sales UOM to something different. But it is both gray out and in the Stock profile. Is there any way to unlock the UOM to make this change and the Base UOM is each. Much thanks
Hi Folks! We have a client who would like to simplify the creation of new Stock Items in a Multi-warehouse environment. Other than using GI’s as a data provider and running imports, does anyone have any tools/utilities to automatically establish item warehouse details using some default settings for newly created stock items? I’ve not gotten into the workflow designer as of yet to see if there’s anything there that could assist, but if you all have some tips or tools to assist, please reply.
Shipment status broken again, confirmed status shipment can neither be prepared invoice nor correct shipment.
Hello, We are using 2020R2 103 version. We encountered another shipment status issue. We are having shipment as status “confirmed”.However, the user can not “prepare invoice” based on it. It will show error: And, the user can not “correct shipment” . It will show error: I checked the Database, it looks like for some unknown reason , the “confirmed” column has not been set to 1. This is the second time, our user met the status mess up issue. Unfortunately, we do not know how to reproduce it.Can Acumatica developers do an in-depth research to solve the root cause?
Can we have a "Document status validation" function? causing some document got incorrect status by unknown reason.
Hello, After upgrading to 2020R2, build 203, we are suffering shipment status issue now and then.like below: Poorly, today we encounter another status issue on Sales order screen.1 Sales order says “shipping” status but no related shipment can be found. Why and how did this issue happen is unknown. Maybe it is a rare case. However, anytime, if this kind of issue happens, what can the user do ? The user has to wait the techical staff to fix in Database. In Acumatica we are already having “balance validation” and “inventory validation” functions. So can we also have a “status validation” function, then system can in some way correct some incorrect status documents.
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.