Distribution

We are trying to combine shipments for a specific customer. Have a job scheduled to run weekly to Create Shipments. Trying to create them to ship a few days from when the job runs for anything scheduled to ship within the next week and a half. This screenshot is from 5/15, to help understand the relative dates:Location, ship via, use customer’s account are all the same across 3 orders, and the order line ship on dates are before 5/25. SO Order Type ship separately is unchecked, and it’s unchecked for each order. We ended up with 3 shipments, each with a different ship date. It looks like instead of combining the shipments into one on the date specified as Shipment Date in the automation, it is using the SO Order Line Ship On date and making separate shipments. Is this correct behavior? Does anyone know of a way to automate combining shipments with different ship on dates within a window?

Has anyone had an issue with acumatica pulling all the info from UPS back into the shipment with the shipping integration tool?  I’ve noticed that when I get a shipment that has at least 10 boxes/packages, it won’t pull all the tracking numbers back into acumatica and the shipping cost has to be adjusted as well because its only pulling the cost of the boxes pulled back into the shipment in acumatica.  

Hi Everyone,  I want to create a KPI dashboard for our warehouse. Besides the obvious number of open/late shipments, we want to measure productivity. i.e., the average time it takes to pick a shipment after the pick ticket is printed/assigned. How often do locations need to be changed due to inaccurate inventory. I'm not sure where this information is stored in Acumatica, if it is at all. Can anyone shed some light on this? Does anyone have any ideas?  

Does anyone know what Acumatica’s response to this is?  The original post was 10 months ago and it seems like we are 3 wks away from our UPS utility not functioning with still no solution available from Acumatica. I have added a new branch and am unable to setup UPS for that facility which is a problem.  

I am new to GI’s. I am trying to expose the G/L accounts for the items below for the GI Inquiry under Vendors. I also need to expose the Account e-mail field to the Vendor GI Inquiry as well. Also, what table do I need to add below to get the above Data: Also, what relations do I need to add to below.  Any help would be greatly appreciated?  Thanks,Frances    

Are you using Pacejet for international shipments?  If so, are you able to produce a commercial invoice in base or CAD currency?  Seeking advice based on your experience. 

Is there a way for the Attributes to appear on the po screen?

We have individual Sales Orders that require multiple shipping methods. Is there any way to override the Ship Via designated in the SO Header on the Detail Line?

Hi All, This is my first customization in acumatica. I am an absolute beginner to this. My requirement is as below:I need to update the default scan qty from 1 to 0 in pick pack ship and other similar forms( both web and mobile app). Currently its getting populated with 1 as default value. Please help me on this, how to do this and where to start with.  If this was a customization in base code, it would be easy to do so, by grabbing the development branch and setting a debugger to find out the flow. Since this has quite a different approach whichis new to me, so getting hard time to figure out.Any reference to the or something similar are really appreciated.

I am trying to reverse an adjustment that was released with the wrong date, but am getting the following error.  I already have ‘Allow Negative Quantity’ selected on the Item Class screen.  Is there any way to get around this error?    

Hi All,Is there any report to see the customers’ available credit limits ? Under the “Customers Profile” report, we only can see the credit limit. Unfortunately available/remaining credit limit is not captured to that report.Thank you 

Hello,I am trying to create a GI that shows Vendor ID, Vendor Name, and Lead Time so I can revise it and upload back to Acumatica using a Data Provider/Import Scenario. I cannot find the field for vendor lead time in the GI builder.  Anybody know which table to add? 

My boss wants that when a new order is created in the system, a new task is automatically created for certain employees. However, I can only select one employee in the Task Templates screen, not several. Does anyone know if it's somehow possible to set this up to create a task for several employees at the same time? It should also be set up that if one of these employees is the one who created the order, the task will not be created for him.   

We’ve recently gotten a new warehouse that will use a new order type. We want to be able to print the pick tickets directly to that warehouse only from that specific order type. I am unable to find directions to do this… I have added the new printers in device hub, they’re seen in Acumatica and active, I just cannot for the life of me figure this out.Thank you so much for taking the time to look at this

Does each Vendor Discount Code in AP204000 need to be unique to a vendor? This seems unnecessary if the discount code is then assigned to a vendor on the Vendor Discounts form AP205000. 

Has anyone found an easy way to reverse an incorrect inventory transfer that was released in error?

Hello, I wonder if someone can help me add Mark for PO to the sales order list screen. I searched the GI inquiry tables, and I could not find any filed for Mark for PO. It is not on the column configrations 

Hello,I have a SO with 22 lines that all ship at different times.  I have shipped Line 1, but once I did that Acumatica ‘Completed’ the SO.  My intent was to leave the SO open until all items have shipped.  My questions are:Why did it close the SO without shipping complete? Can I reopen this SO so I can get the ‘Create Shipment’ prompt again?Thanks! 

How to enable subitem in module inventory in acumatica version 2023R2

Hi,I'm seeking assistance with an issue regarding duplicate lines generated in the packing slip report. The problem arises when linking the ARTran table to the SOOrderShipment table.I have attached the packing slip report for reference. Could someone please provide guidance on resolving this issue? Thank you in advance for your assistance.

We drop-ship countertops (inventory ID is SOLID SURFACE) to the end customer. We have the SKU set up so it defaults to Mark for PO = TRUE with type drop ship. This works when adding directly to the Sales Order. However, all our orders begin as Opportunities and are subsequently converted to Sales Orders. I have just noticed when adding SOLID SURFACE to an Opportunity, this default Mark for PO button does not get clicked. Once it is converted from Opportunity to Sales Order, the Mark for PO button is not clicked. This results in Purchasing not being flagged to send a PO for this item. Is this a feature or a bug? Why do the defaults not apply to the Opportunity? Anyway to get around this?    

Hi,If we create a shipment with a future date, so it can be picked and staged, there is nothing preventing or warning a user from completing the shipment early.Is this correct?Basically, we want the shipment to ship only on its shipment date.We use Pick, Pack, and Ship.I have looked here in the forums and in the documentation but unable to find a solution. Thanks in advance.

I’m currently using Acumatica 2023 R1. When I upload a vendor price worksheet with multiple lines, only the last line shows up. No issues with the sales price worksheet though.Has anyone had a similar issue and/or have a fix?Thanks!

Can you merge duplicate items into one item number?The intent is to preserve the history of both items in one (These items should have always been one) Quantities of both items should be summed together into 1 fieldMerging of duplicate entries can already be done in Acumatica for Business Accounts and Customers, I am looking for largely the same thing for items.Can this be done?