Skip to main content

Distribution

Inventory, Orders Management, Warehouse Operations

  • 2,294 Topics
  • 8,556 Replies
2294 Topics
A
Freshman I
asinghFreshman I
asked in Distribution
Add Multiple Requistions to Single PO

Hi All Is there any workflow in Acumatica to have multiple requsitions from the same vendor be added to one purchase order? Thanks Amit

152
A
Freshman I
H
Semi-Pro II
HarrySemi-Pro II
asked in Distribution
Auto generated invoices

Hello all, I have an SO created with non stock items, and I dont know how bt the invoice for the sales order got created automatically. It has the below status: The Shipments tab → Status: Auto generated.

185
H
Semi-Pro II
Godro
Freshman I
GodroFreshman I
asked in Distribution
Ship Station integration to Acumatica 2024 R1

What functionality should I expect from the ShipStation integration? I’ve installed the customization, connected both systems within ShipStation, and started configuring ShipStation in Acumatica. However, I’m struggling to get orders to sync to ShipStation. What needs to be set up in Ship Via? Is a carrier required? I’ve reviewed the user guide from ShipStation but still can’t get the orders to sync. Additionally, will the "Shop for Rates" feature be available with this integration? I haven’t been able to find any clear resources on this—can you help?

8612
Naveen Boga
Captain II
F
Freshman I
fdelrioFreshman I
asked in Distribution
Zero Cost Kit Disassemblies

Looking for some help understanding why when doing a Kit Disassembly some items do not automatically show a cost in them? Cost appears when the Kit is Assembled, but when doing the Disassembly some of the kit components show a cost and some don’t. All stock items show costs in the Stock Items > Price/Cost tab so I’m having a hard time understanding what I need to fix to resolve this issue. Thanks in advance!

213
bwhite49
Captain I
AndreasKleinfeld72
Varsity II
AndreasKleinfeld72Varsity II
asked in Distribution
Handling of reusable bins or pallets with a balance per customer

In many industries (automotive,...) produced parts sent out in reusable bins and / or pallets. These reusable bins must be tracked, and ultimately, you need to know how many reusable items each customer still possesses in order to reclaim them if necessary. How do you deal with these requirements?

70
AndreasKleinfeld72
Varsity II
B
Jr Varsity III
bradmestachJr Varsity III
asked in Distribution
Inventory Planning, why does it not count a transfer order as supply?

When running the inventory planning module, I create the transfer order from the inventory planning screen. No matter what status I have that order in, Open, On Hold, Back Order, the inventory planning does not count it as supply. I know this because when I regen the inventory planning the demand comes back like it is not fulfilled. Why is this a problem?Sometime, the transfer order cannot be fulfilled right away. Then the regen happens and another transfer order gets created and now we have too much supply coming to fulfill that order once we do get stock. Has anyone else seen this as a problem for them? How do you handle it?

25221
R
Varsity I
M
Jr Varsity II
MWijesuriya43Jr Varsity II
asked in Distribution
How to generate inventory balance report for a specific date?

Hi, Is there a way we can generate Inventory Balance report for a sepcific date. As an example, I want to see the inventory available balances as per the date of 5th April 2025. How can we fullfil this requirement? Thanks!

262
M
Jr Varsity II
KarthikGajendran
Acumatica Moderator
KarthikGajendranAcumatica Moderator
posted in Distribution
Seeking for customers who trade with Amazon Vendor Central

Hello Everyone, Acumatica is currently evaluating a native integration with Amazon Vendor Central, and we are seeking insights from customers who are already trading on the platform. If you are currently working with Amazon Vendor Central, we would love to hear from you! Your insights will be help in shaping this integration to better align with your business needs. Please feel free to comment on this post or reach out to me directly via email at karthik.gajendran@acumatica.com. Looking forward to connecting with you soon! Thank you

788
A
Freshman I
K
Freshman I
kkrausFreshman I
asked in Distribution
FedEx Forbidden.Error when trying to confirm Shipment

When trying to confirm a shipment I get the error: “Carrier Service returned error. FEDEX: FORBIDDEN.ERROR We could not authorize your credentials. Please check your permissions and try again.” The carrier page for FedEx says the connection is successful, so I’m at a loss of what the issue could be. The Error

1097
D
Jr Varsity II
N
Jr Varsity II
nicolestantonJr Varsity II
asked in Distribution
Need Total Inventory Quantity and Value for 1/1/25 for Tax Purposes

I’ve scoured this forum and can’t find any suggestions, so I’m hoping someone can offer suggestions. We are 2 years into Acumatica and still struggle to find very simple reporting that was readily available in QuickBooks. We are filing personal property taxes and need a snapshot of the quantity of items in inventory as of 1/1/25 AND the valuation of that inventory. Is there something like that already built out in Acumatica? It doesn’t seem like a huge ask, and I’m sure we are not the only company who would need this kind of data, but I can’t find it. Inventory Balance - gives me a current count of thousands of inventory items, no total count, no valuation, no way to filter by date Historical Inventory Balance - allows me to pick a MONTH, not a specific date; no total count, no valuation Inventory Valuation - gives me a total quantity and total cost, however I can’t backdate it at all Historical Inventory Valuation – if I tell it to pull 01-2025, that doesn’t necessarily give me data f

364
davidnavasardyan
Jr Varsity I
K
Semi-Pro II
kokjietanSemi-Pro II
asked in Distribution
Obtaining last cost with cost layers included (eg. PPV or landed cost)

On the Inventory Transaction History screen, there is a handy button to ‘Include landed cost in unit cost’. Interestingly, this also updates the impact of any PPV cost adjustments on the receipt. Without PPV (original PR price) & with PPV (after PPV revalued) Is there any easy method to retrieve this additional cost layer information through a GI, so we can push it through an import scenario? Specifically, we need to update the Last Cost of specific valued items so that it reflects the actual receipt cost with PPV revaluation included. Otherwise, our cost rolls are taking the incorrect last cost sans-PPV revaluation.

2143
davidnavasardyan
Jr Varsity I
M
Freshman II
mattjesse68
asked in Distribution
Inventory Planning - Not Considering Kit Assembly

Hello, I have a customer who is using DRP and Kit Assembly to plan out what needs to be assembled for Sales Orders that drop in each week. One example is the Kit Assembly pictured below: Even though this Kit Assembly has been created, DRP is not considering it in the Inventory Planning calculations. The customer is understandably concerned because they don’t want to create unneeded inventory by creating new Kit Assemblies every day, as Inventory Planning Display is suggesting: The Kit Assembly is On Hold, but that is taken care of in Inventory Planning Preferences: I have exhausted what I suspect could be the issue including the following: Kit Assembly and Distribution Requirements Planning are both enabled on the Enable/Disable Features (CS100000) form The Stock Item has the “Is a kit” box checked The Kit Specification is Active The General tab on the Stock Item has a Planning Method of DRP The Inventory Planning tab on the Stock Item has “Kit Assembly” as the Source The PACKAGING War

745
valentynbeznosiuk
Jr Varsity I
plambert
Jr Varsity III
plambertJr Varsity III
asked in Distribution
Carrier Integration: Manual Packing in Pacejet for Shipments without packages

Hello all, We are running into a potential bug with the PaceJet carrier integration. We recently updated to 24R2 in an attempt to have the following workflow without customization: Create a Sales Order with PaceJet as the Carrier for shipping. Create a Shipment for the Sales Order from the Process Orders screen. Use the Pick, Pack and Ship screen to handle picking and, once completed, confirm the shipment. Pack the shipment in PaceJet manually. Update the Acumatica Shipment from the Process Shipments screen. The issue we encounter is that PaceJet does not receive shipment information unless a shipment has at least one package added to it before shipment confirmation in Acumatica. We have the Carrier configured with the Usage Scenario of ‘Manual Packing and Shipping in Pacejet’, which appears to mean that all packing will be done in PaceJet so the Acumatica shipment will receive all of the box information externally. Yet when a shipment without any packages is confirmed, the PaceJet Sta

515
Chris Hackett
Community Manager
D
Jr Varsity III
dsenevirathne54Jr Varsity III
asked in Distribution
Total Cost Field in Purchase Receipt tab is not available in 2024-R1

Hi, In the 2024-R1 I don't see the Total Cost field on the Purchase Receipt - Summary area. Is this a change with 2024-R1? Please refer below screenshots. 2023- R1 2024-R1 Thank you, Dulanjana

56917
sroberts29
Freshman II
N
nheinber
asked in Distribution
Stock Item - Conversion Factor change on in use material

We recently had a vendor change how they were selling some of their material and we wanted to update the Conversion Factor on the Stock Item to match the changes. Currently the material is on several orders and it errors saying “The unit conversion cannot be modified because it is currently in use in the following document -***”. Is there a way around this without having to remove the material from all the Purchase and Sales orders or some way to make it apply going forward or is removal the only way?

423
A
Captain II
P
Freshman II
Pinny
asked in Distribution
Scan POD Documents

I’m looking for a solution how to scan POD documents in bulk (300 pages at a time) and the system should store them in the proper SO within Acumatica (identifying the proper order number from the document bar code) and then email them together as page two when creating and sending invoices to our customers, we don't want to use a mobile app for signatures, we hand a piece of paper to the driver for every delivery and when they return the signed document we want to have them in the system and use it to email it together with the invoice as proof of receiving the goods, any idea how to accomplish this would be very helpful, do to the volume scanning and dragging each document wont be an option, Thank you.

3466
lauraj46
Captain II
vidyakeerthik
Freshman II
vidyakeerthikFreshman II
asked in Distribution
Payments & Applications screen - Planning to create Payment for Order with Pending approval status

Hello everyone, As part of customization, we are trying to allow creating a Payment for a Sales order which is in pending approval status. Standard Acumatica has a restriction here to avoid Payment creation in this case, to remove the restriction for the Pending Approval status, we tried to override the Restrctor attribute as below, which is not helpful, and we don’t see this restriction, anywhere else in the code. Tried Modifying the PXRestrictor attribute remove SOOrderStatus.pendingApproval , which didn’t help. As a next step, tried with Override the AdjdOrderNbr Selector without PXRestrictor still giving same error, and unable to create the Payment. Steps to verify this:• Create a Sales Order, and ensure Order status is Pending approval• Navigate to Payments and Applications screen, try to create a new Payment with the same customer used in the Sales Order, and then try to add the select the Sales order from the Sales Orders tab• Tab out here, or saving the record pops out the erro

201
Naveen Boga
Captain II
K
Freshman II
kapilc79Freshman II
asked in Distribution
While Converting Purchase to Fixed Asset Getting an Error

I am getting the below error while converting Purchase to Fixed Asset. “Both Debit and Credit parts of transaction are not zero. Exiting with error.”

402
K
Freshman II
KellySquizzero24
Acumatica Moderator
KellySquizzero24Acumatica Moderator
published in Distribution
Acumatica Labs Program: Advanced Kitting

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

85012
Dana Moffat
Acumatica Moderator
xkylewrightx
Semi-Pro I
xkylewrightxSemi-Pro I
asked in Distribution
Cannot Create Shipment: Order does not contain any items planned for shipment on (date)

Hello, I was wondering if anyone knows if there is a resolution for this issue: The following error appears when attempting to create a shipment for an order for which the Sched. Shipment date is greater than the current date. This would be considered a bug to us, as there is no reason you should be prevented from shipping an order earlier than requested. This is a required field that is pre-populated from the SO Requested On field, and results in an additional unnecessary and confusing step of manually altering the scheduled shipment date to the current day before creating the shipment. We are shipping non-stock items, back order allowed, allow negative quantity, but that should not matter. I know this was previously a known issue but we are using 2023 R1 where it was supposedly resolved years ago TYVM! Kyle

99613
B
Freshman I
C
Jr Varsity II
cviannaJr Varsity II
asked in Distribution
Inventory Item Restriction by Branch

Hello everyone, I have been trying to setup a restriction for an inventory item by branch, meaning that when a user has branch A selected during Sales Order creation, he is able to add the item to the SO, however if the user has branch B selected, the item is not shown for selection. This item is only manufactured in branch A and shipped directly to customers. The restriction is needed because we have users that enter orders to branches A and B. I have tried to do this with restriction groups, but only managed to do this with users + inventory item, which is not the case because the user that has access to the item can still include it in the SO when he is in branch B, AKA the wrong branch. Is there another way to do this that I am not seeing? Thanks, Clauber

1669
C
Jr Varsity II
L
Jr Varsity III
lairdtimJr Varsity III
asked in Distribution
Prevent PO Receipt to Warehouse different than PO Warehouse

At least in the way we’re currently configured (on 23R1) we have the ability to receive a purchase order into an alternate warehouse; the PO Line could be written for Warehouse TX, while the item can be received into warehouse AZ. We do a number of virtual warehouses for a few reasons, but the biggest is to keep costs from potentially intermingling. I have warehouses TX1 and TX2, and if we get a good deal for a specific customer job, we’ll purchase and receive the material for that customer into TX2, while the regular inventory is purchased and received into TX1. We have a problem with a warehouse getting complacent, not checking where the material should be received, and receiving everything into TX1 even if the PO is written for TX2. We can transfer it back out, but it impacts average cost of those items in TX1 that we have to adjust for as well. It would be easier if there were a setting that said that purchase receipts could only be done for PO lines for the same warehouse.

331
chameera71
Varsity I
D
Jr Varsity III
DawoodJr Varsity III
asked in Distribution
Updating Vendor Price Using Vendor Price Worksheets

I ran a test and updated a stock item price using the Vendor Price Worksheet. I added a pending price of $13.76 for the item, but it didn’t update the cost on the stock item or reflect the new price in the Vendor Last Price field either. I also created a purchase order and added the item, but it still pulled the old price. I'm wondering—where does the system update the cost for this item?

191
O
Acumatica Employee
K
Jr Varsity II
kudzaim20Jr Varsity II
asked in Distribution
How to sum Tax ID total on report

Good day I want to sum my tax totals by Tax ID from the DAC ARTax. I have a scenario where I have to taxes on a sales order invoice how best can I sum them on the report by the Tax ID as per the screenshot below In my case for this invoice I have a tax total of 105.88, and on the invoice print out in the footer I want to split the two as per the above screenshot. I have the formula =IIf([ARTax.TaxID]='SVUS',Sum([ARTax.CuryTaxAmt]),0) for the SVUS Tax ID and =IIf([ARTax.TaxID]='SUTAXUSD',Sum([ARTax.CuryTaxAmt]),0) FOR the SUTAXUSD ,Tax ID. However on the invoice template the split is not coming out correctly what could I be missing? The computation is not coming out as desired which should be: Sub Total: 542.90 Less Discount 32.64 Invoice Total 510.26 Tax Total 76.54 Surtax Total 29.34 Total 616.14 I added the ARTax table on my schema to my report design as shown below

744
Chris Hackett
Community Manager
K
Freshman I
kkomlodi82Freshman I
asked in Distribution
Using Inventory Item Access to restrict Item by Branch

Has anyone figured out a way to restrict Inventory Stock Item visibility by Branch/Company?

3502
dannyfisher34
Freshman II

Go to

Discussion Forums
Financials
Distribution
Manufacturing
Construction
CRM
Field Service
Retail
Payroll
Professional Services
Low Code | No Code Customizations or Integrations
Develop Customizations
Develop Integrations with Web Services | APIs
Other Developer Topics
ISV Solutions
Configuration and Installation
Reports and Generic Inquires
Import and Export Scenarios
System Health and Performance
Community site discussions
Community Introductions
Everything Else
Technology Partners and Customers
News & Announcements

Tags

Most helpful members this week

Badge winners

Show all badges
Terms & ConditionsCookie settings

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
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved