Distribution

Hi,I need track the COGS and Sales for a specific customer . I was looking for a way to set up the COGS and sales account to be picked based on this specific customer.This seems  not possible with the available options and I identified one issue which is if we have set up the posting class to pick the sales account by the inventory and also we have a different sales account in the customer’s GL accounts, the system always picks the account from the Inventory ID. How can I set the priority to pick the account entered in the customer rather than picking it from inventory ID?Further, I can check the sales for the specific customer in the sales account, since in the account details customer is available. I can filter and see. But in the COGS account, the business account is not available. I will be able to create a GI to connect and show the customer for COGS transactions but Do you see any other options to see the COGS for a specific customer?Thank You,Dulanjana 

We recently upgraded from 23R1 to 25R1.  A sidepanel added in 24R1 is something we’ve been looking forward to--the new “Related Return Documents” in Sales Orders.Unfortunately only our Admin role seems to have access to the sidepanel.  When I look at roles like our SO Clerk and drill down to Sales Orders, Sales Orders, Sales Order (where the sidepanel security lives), it shows that security is inherited.  If I open a user in that role in the “Access Rights by User” screen and drill down, the specific security listed for that sidepanel is “Edit”.  My guess is that either the change from implied Granted security (which was the way 23R1 worked) to Implied Revoked security is causing this, or there may be an actual “Related Return Documents” screen (like with the Stock Items sidepanels) that I need to grant access to.  I’m hoping to grant everyone in the company access to this sidepanel--all of our users have at least View access to the Sales Orders screen.

We changed a stock item's posting class. One year later, it still uses the GL defined in the old one. Why?  The item and posting class Gl accounts are defined with the new accounts.  I’ve looked at the bill of material, the sales order, warehouse, location.  Nothing suggests that the old accounts should be hit.  This is happening for issues out of the warehouse but does not appear to affect receipts.

We need a way to track product continuity by stock item. This includes identifying the customer that purchased the stock item (can be free text but prefer to select actual) and the date through which we commit to keep offering this inventory.  I’m thinking I’ll end up using an attribute option but would love some other suggestions. Is this something restriction groups could be good for? 

Hello! We are just starting to use the Purchase Request / Requisition functionality and we wanted to automate the conversion of Requests → Requisitions. We are going to primarily use this functionality for three types of purchases:General Purchases: Non-SO related goods that can be used anywhere (can be multi-vendor) Quoted Purchases: Quoted goods that are specific to a SO and must be ordered by the quote. By Description Purchases: Typical PPE, Office Supplies, Software, etc. However, I am getting stuck when trying to create automation schedules for these goods. I am having trouble building an automation schedule that creates requisitions by the specific vendor (for general purchases) and another automation schedule that creates requisitions by the specific quote (for quoted purchases).  The two issues are, firstly, when I run an automation schedule for General Purchase requests, I find that regardless of the vendor, all processed lines get combined into one big requisition. The second

On the print confirmation the lines and qty duplicate. lines nbrs 1 and 3.  

I would like to grouped sales by parent/child in generic inquiry to use in a dashboard table. Can someone help with this?

Hello, We’ve been using Acumatica WMS for about two years now. We were initially excited about the picking functionality—using a smartphone via the Acumatica app, or a handheld scanner—but it has not lived up to our expectations. I’m curious if anyone is having success? Here are our pain points: In order to pick via the handheld, you also need a printed picking worksheet to know where to go and what to pick. Using the Review screen during the pick is inefficient to look back-and-forth between. I wish the picking screen would tell you more about where to go, what SKUs and quantities to pick, rather than leaving you “blind” to that information.  It is therefore much easier for our team to just use the printed picking worksheet to pick orders. Using the handheld takes much longer.  As far as I know there’s no way to simply mark a picking worksheet as “picked” in Acumatica. You have to actually scan everything (which takes forever). Therefore our team just deletes the picking worksheet aft

Hi Team,ChatGPT said:I was working on an import scenario to create stock items and encountered the following error during processing:“Account 400100 is a control account for PO, and posting to it is prohibited. Please select a non-control account.”To resolve this, I updated the Chart of Accounts by adding the PO module for account 400100 and enabling Manual Entry.After making these changes, the import processed further but displayed the following warning:“Account 400100 is a control account for PO. Although posting to this account is allowed, we recommend that you select a non-control account.”I’ve attached a screenshot for reference.Could you please help me resolve this issue or suggest any configuration changes needed?

We are trying to link three Sales Order to one Purchase Order. We were able to get one SO linked to the PO, however, the other two cannot link. There’s not even an option to see them. Both are using the same Source and vendor, and part. Any guidance on how to solve this would be greatly appreciated.Purchase OrderOne of the Sales Order 

Hello,I am finding that inventory reports do not reflect cost or quantity properly after using Inventory Adjustments and Inventory Counts.Here’s an example below - we do have a net of 42 and the total cost is appropriate of $312.06.  However, we are showing -84 in our Receiving Location (we run everything in/out of a single location).  This part number was counted, and adjusted up 126, and it was adjusted through the Receiving location, however it’s showing as blank on the report.  Note also that the average cost will be $7.43.  Now, if we look at the Inventory Balance report, since it doesn’t filter to Location, it shows the quantity of 42, but it also shows a Unit Cost of $2.4767, which would be $312.06/126 (total cost divided by the quantity in the ‘phantom’ location’). Looking through the Transaction History we can also see that the Adjustments were always made through the Receiving Location and not a ‘Blank’ Location.​​​​​If I add the Part to a Sales Order, it will correctly bring

We are in the processe of implmentation and I am exploring the Blanket Sales Order functionality and have run into what I belive is an issue related to the “Requested On Date” on the Blanket Order Type.When creating a blanket order you can define the “Requested on Date” for the line item in the Details table (had to add this column),  however when you go to Line Details,  you can only define the “Sched Shipment Date” for each line, not the Requested On Date.      Additionally I have discovered that when creating Child Orders from the Blanket order,  the “Requested On Date” on the Child Sales Order defaults to the Current Date regardless of what is set on the Blanket Order.  I have also observed that the “Scheduled Shipment Date” on the Child Sales Order defaults to the “Scheduled Ship Date” minus the defined number of Lead Time days set on the customer record, which is how I would expect it to behave.My conclusion is that setting the “Requested On Date” and “Scheduled Ship Date” in the

Advanced Kitting Boost your sales with bundles!Acumatica’s Advanced Sales Order Kitting capability is designed to streamline and optimize your sales bundles. This feature improves visibility into non-stock kit components and inventory availability, and significantly boosts profitability by enabling better control over pricing and margins. It streamlines the order entry process, allowing customer service representatives to customize sales orders and packing lists, which leads to increased operational efficiency and a superior customer experience.  Additional highlights of this solution can be found below.Be a part of our Acumatica Labs Program to implement this innovative solution and help shape the future of sales order kitting! If you’re interested in participating, please complete this short qualification questionnaire.  This will allow us to consider you for the program. We will review your submission and get back to you within 5 business days to confirm your qualification. Improve 

Hello,I have several Sales Orders that are completely shipped and invoiced, but are stuck on Open or Back Order status.  I have even reopened them, added lines, shipped everything, invoiced it (with $0 amounts) and tried to close it, but it will not work.  All of the invoices and shipments related to the SOs have been completed. I have tried using the Process Orders Screen, but it is not showing up in any of the options there either. Curiously, in one example the ordered Quantity in the header is 1,590, but the shipped quantity is 955 on the Shipments tab.  The 955 is the correct quantity, but I’m unable to make a new shipment from the SO or directly from the Shipments screen and adding the SO. I suspect there were lines on this order that were deleted, so the header just never updates, but that would be very strange if the order can never be closed now because of that.I’ve also tried “Recalculate Prices”, which of course doesn’t help.Has anyone experienced something like this?  Is the

Is there a setting or other method to restrict item purchasing ONLY to vendors listed for an item AND marked as “active”? I’d like to be able to turn on/off the ability to use a vendor for specific parts. In this instance, we are creating the POs manually, not via automation. Currently, I can create a PO for any part and any vendor, which has led to some mistakes. Ideas?

We have a customer that prefers us to master pack--packing several small boxes into a single larger box--so they don’t receive so many individual packages.Here’s our current process:In Acumatica, we pack everything into small boxes (for example, a box with carton ID C01) and enter the contents and weight for each small box. We can usually fit about six C01 boxes into one larger box, a C08. We then move to ShipRush (third-party shipping software), where we enter the dimensions for the large/master box (the C08), generate the FedEx shipping labels, and manually add the master box with the tracking numbers back into the shipment in Acumatica. In Acumatica, we use a dummy Ship Via (ShipRush FedEx), instead of FedEx Ground, so it doesn’t automatically populate tracking numbers.This method works, but it feels clunky.My question:Is there a way to master pack directly in Acumatica without relying on ShipRush? For example: could we create a special carton ID (like “CIP”-carton inner pack) and h

We have run into an issue where our purchasing agent went to create a drop ship purchase order but only selected one of the two items needed for the order. Once realizing this they deleted the purchase order and unlinked it from the SO as prompted, but doing this causes the item attached to this deleted purchase order to no longer be listed when going to create a new purchase order. The item is still marked for PO as Drop-Ship in the Sales Order and doesn’t show it linked to any PO. I am unable to find a way to manually add these to a drop-ship order either.

Looking for a good solution to implement cross-docking processes in Acumatica.   Basically, we pull inventory available to a “stage” or “picking” location for a SO then wait for other SO items to come in on a PO that should get cross-docked to shipping and get married with the “stagged” inventory quickly.  

Client is going live over the weekend and we need to pull in the purchase order receipts for the goods received not invoiced report.  Do we take the report from the legacy system and receive them into Acumatica and just do a manual reversal of the gl entries created?  I do not see anything on this process when I search for it.

Hello everyone  My company requires to open several shipments that have several lines (products) of one SO. Acumatica doesn’t allow you to have an open (unconfirmed) shipment add modify the sale order simultaneously. I need to  create multiple open shipments at the same time. If you create one shipment it lock the SO and doesn’t allow you to create additional shipments without confirming them. Does anyone know how to unlock the SO? 

Is there are report or GI in Acumatica where one can see a customers purchase history by item?

As a commercial importer of lighting products from all over the world, we also distribute in all of North America. In the past uploading Price lists and modifying our prices was once or twice a year during the beginning of the year. We only used to upload current inventory or requested inventory items into Acumatica. This was a 6 transaction event for each product due to currencies, landing factors, shipping and duties. However as we have grown we need to upload all our vendor price lists. This did not seem to be an issue: until the world changed this January and pricing needs to be updated monthly.  I cannot express the frustration of having to update prices and as a result  we are being choked and asked to upgrade to large enterprise level “no Limits” licenses.We are a small/medium size business and ave spent over 500k getting Acumatica to work for our business. I want to see if others are having the same issue, there should be allowed a scheduled server downtime to upload, update or

Hey there. I have a SO that had a drop ship item on it. Twice as much product was received via a purchase receipt. The PR was released but not billed. The customer has also not been invoiced for the “extra” product received. I saw some documentation on how to undo this if the product had been invoiced to the customer and billed by the vendor. Do I need to go thru that entire process even though the customer has not been invoiced for the additional product and the PR does not have an AP Bill?

Hello,   We recently updated our module. When generating purchase orders the warehouse location is auto defaulting to the wrong location. how would i mass change this to the correct location?  After reviewing Vendor profiles, we discovered the purchase settings for WAREHOUSE within the profile is blank. With that said we cannot figure out why it would default to the wrong location and why our data was deleted after the update.  Not sure if we will have to change this for each individual vendor one at a time or if a mass data dump possible.  thank you. 

Hi,Have noticed that when it comes to shipping our manufactured items, the Shipment document will split one shipped item ID into multiple lines, which corresponds to one for each quantity we produced under Move/Labor under Manufacturing.I presume this is because an allocation is created for each Move/Labor document, as opposed to the gross produced quantity as a whole.Needless to say, this can get rather messy when shipping, if for example we manufacture 1 units per day for 60 days. When we ship the 60 units, we end up with a long Shipment document of 60 lines of the identical item with 1 qty each and a puzzled freight carrier.Is there any way of consolidating the Shipment document to present this as one shipment line based solely on the Inventory ID?Thanks in advance!