Skip to main content

Distribution

Inventory, Orders Management, Warehouse Operations

  • 2,411 Topics
  • 8,985 Replies
2411 Topics
StevenRatner
Varsity I
StevenRatnerVarsity I
asked in Distribution
Purchase Receipt - Transfer Receipt - Import Scenario Error

Hi -I have created the following import scenario for creating a purchase receipt - transfer receipt.  When running the import I get the following error which is very vague. “The system failed to commit the openOrders row.”  When walking it through manually it works fine though.  This is import is built on 23.115. Does anyone have any idea why.  I have attached my xml as well.   

1094
Chris Hackett
Community Manager
J
Freshman I
JoeYTGFreshman I
asked in Distribution
Error: Inserting 'Carrier Plugin'

Hello -  We most recently upgraded to 2023R1 update 11 and noticed that we now no longer have the option of setting up a new carrier native within Acumatica.  This was a feature that we have full access to prior to the upgrade that has no gone away.  Do note - we do have the shipping carrier integration as part of our license. Here is what I see whenever I try to go in and setup a new carrier:  Luckily, I am able to still use my existing carriers that I set up prior to the upgrade, but when it comes to setting up the new REST API’s or a new carrier, I’m out of luck.Is this an issue with this particular version of Acumatica or is this an issue with the configuration on our upgrade?

31311
AndrewBGL
Pro I
apretorius62
Freshman I
apretorius62Freshman I
asked in Distribution
Stock Issues & Reason Codes

HiI have a challenge with reason codes in stock issue screen.My customer is a farming concern and have several sub accounts which need to absorb stock issue cost being fertilizer or chemicals, etc.Why can one not choose an account and sub account on this graph. We now have to create hundreds of reason codes representing account and subaccount combinations. its not practical. when you in the issue screen on the reason code field and one start typing for a quick search suggestion, the only value that it runs on is the reason code itself, not the description and not the account and not the subaccount either. If the suggestive search could run on description it can help already.I will appreciate some advice on this please. thank you

1731
Laura02
Captain II
A
Jr Varsity II
amitkaryekarJr Varsity II
asked in Distribution
Inventory Posting classes not being used when creating ISSUE

Hi All,Just to give details about the Problem I am facing here, the process my customer is using is that they receipt inventory and store inventory. They distribute this inventory  to different internal warehouses. Each inventory is consumed so an IN ISSUE is raised for this when the goods are consumed.We have different posting classes assigned to each inventory classes which in turn has the COGS account.I have noticed when I raise an issue it uses reason code “ISSUE” GL account code when a GL batch is created. I can create different reason codes for each item class but then user will need to select the right reason code based on each line item and its associated reason code linking account which makes it difficult double entry.Can anyone suggest a better alternative please?can we force the system to use posting class when an ISSUE is raised.Happy to have a discussion and provide more details if necessary.Please see an example below. 

2015
Laura02
Captain II
M
MichaelMason
asked in Distribution
Transferring Nonstock Items Between Warehouses

Hello, I trying to find a good answer to the below: We want to input our maintenance items in as non-stock items (we do not track quantity, and most are made on site and we do not want to create work orders for them) However, our main site/warehouse handles almost all of the stock and ships it to our 3 other warehouses as needed. We would like to be able to do a transfer of the non-stock item (cost) to the warehouse that is receiving the part. The cost of the materials and labor are all already calculated in the cost of the Maintenace part. When I try to do a 2-step transfer, I am able to save the transfer, create a shipment, and update IN. When I try to receive at the receiving warehouse the transfer doesn’t show up, and when I check the transfer order it shows as completed. However, I am seeing no GL transaction associated with this either. This also applies to our non-stock production materials (screws, nuts, bolts, rivets etc.) Where a plant might need to supply another plant and w

920
M
A
Jr Varsity II
aidenwills15Jr Varsity II
asked in Distribution
Vendor ID number generation

Is it possible for the vendor ID number to be auto generated with the first 3 letters of the vendor, a number to differentiate vendors with the same first 3 letters, and then a V at the end upon vendor creation?For example, when I add a vendor for West Side Materials, have the system automatically create the vendor ID WES001V. Then add Wesley’s Supplies Co. and have the system create the ID WES002V.Thank you all for your time!

4524
Chris Hackett
Community Manager
K
Jr Varsity II
kevinheng21Jr Varsity II
asked in Distribution
How to change decimal point to 3 digit

 

10779
M
Freshman I
dougmcbride79
Semi-Pro I
dougmcbride79Semi-Pro I
asked in Distribution
Best Practices: Owner of Business Account

What is the best business practice for deciding who is the owner of the Business Account?  Is it the salesperson assigned to the Business Account?  Thank you for any help you can provide. 

952
dougmcbride79
Semi-Pro I
M
Freshman I
Mayssa2Freshman I
asked in Distribution
Generic inquery & Business Event & Tracking

hello, I'm trying to set up an event to receive notification when payment details change.I've set up the audit trail, a generic query showing updates and the event, but I'm not getting the notification that a new change has been made. Some help please..Thank you in advance. 

621
miguel80
Semi-Pro III
N
Freshman I
NathanKahnFreshman I
asked in Distribution
How to delete unsent customer documents

Hello, in this screenshot, how can I either delete these records or mark them as sent?  That’s question #1.  Question #2 is why are they there in the first place?  We are emailing these, I can look at the Activities tab on the customer and see that it was sent.  I do have “send user emails immediately” checked in Email Preferences.  Is that causing it?Thanks.

2064
J
Varsity I
J
jalasmitha
asked in Distribution
Warehouse Address should automatically updated when we select building ID or should we update manually in both screens

when we select Building ID in warehouse the address is not automatically fetching into address section or should we update manually in both screens.  

150
J
rohansa15
Freshman II
rohansa15Freshman II
asked in Distribution
The Documents Not Posted to Inventory button is disabled

Getting an error when trying to open Documents Not Posted to Inventory. Error occurs as follows - The Documents Not Posted to Inventory button is disabled. If anyone has any idea about it please let me know. Thank you

453
rohansa15
Freshman II
R
Jr Varsity III
RobLoweJr Varsity III
asked in Distribution
Get Add Items button to look at Non Stock as well as Stock items

In a Purchase Order, could the ADD ITEMS button be made to look at both Stock and Non Stock Items? Currently it only looks at Stock Items. 

432
jamesh
Semi-Pro I
E
Freshman I
Eddier47Freshman I
asked in Distribution
Allocations on Transfer orders

I want to see if other users have the same issue or requirement as we do with Transfer Orders.We have a production warehouse and a sales warehouse, items produced in PW get transferred to SW to ship. When we produce make to order items we have an issue with allocations.The sales order creates a requirement and allocation. When we create a transfer, in order to ship the item from one warehouse to the other you are required to allocate to the TR in order to ship. In order to do this we have to remove the allocation from the sales order and allocate the transfer order so we can create a shipment. after item is received at the sales warehouse we have to reallocate the sales order. I’d like to be able to ship the transfer without affecting my sales order allocation or creating a duplicate requirement.  Second issue:If we want to move inventory from one warehouse to the other but the items are on a purchase order and not yet received we can’t. if we create a transfer and leave it to be fulfi

951
aclair
Freshman I
Foujan
Jr Varsity II
FoujanJr Varsity II
asked in Distribution
How multiple warehouse staff can receive same purchase order using scanners?

Our client has equipped their warehouse staff with scanners, and within a single purchase order, there are multiple lines to be received. To streamline the process and make it more efficient, they are looking to have multiple users receive the same order. They have divided the lines among them and instructed them to relocate the received items within the warehouse.Upon testing the Receive and Put Away function, we encountered an issue where it generates a new purchase receipt for additional quantities, instead of receiving the current ordered item.Is this scenario feasible?Thanks,

431
Dana Moffat
Acumatica Moderator
A
amutha64
asked in Distribution
How to change the Warehouse ID while using copying the Inventory transfer?

How to change the Warehouse ID while using copying the Inventory transfer?

301
Laura02
Captain II
D
Jr Varsity II
dnguJr Varsity II
asked in Distribution
Changing non-stock items to stock items

We have a number of non-stock items that we wanted to change them to stock items.  Is there a way to do so?  Please advise, thanks...

2402
D
Jr Varsity II
J
jmiller27
asked in Distribution
Remove Convert Non-Stock Item

How do you remove someone’s ability to Convert to Non-Stock Item? 

481
Laura02
Captain II
S
Jr Varsity III
suemackeown13Jr Varsity III
asked in Distribution
Error message: Another process has added 'RolesInGraph' record. Your changes will be lost

When creating a dashboard, the above error message is displayed. What is the reaon for this and how can it be corrected? (2021 R2)

6054
J
Freshman I
kristianharianja
Semi-Pro I
kristianharianjaSemi-Pro I
asked in Distribution
Freight in CR Sales Quote

I have to say there is a lot to be done to sales quote in terms of adding freight. Additional shipping information that is added recently is appreciated but still not enough, it doesn’t have the ability to just add freight price and premium freight price. I can’t see either the amount of freight calculated after specifying ship via, zone, etc anywhere in the screen/form. We ended up using a non-stock to charge freight manually.Is there any enhancement planned around this? If there is, in what version?

2465
A
Jr Varsity III
A
Freshman II
Andre17Freshman II
asked in Distribution
Warehouse golden path

We have a situation where we have 9 warehouses all physically next door to each other, Some warehouses have an upper area. These warehouses store different items types / value in their respective warehouse. As per Acumatica these 9 warehouses all belong to the same building thus making scan and transfer possible. But the only time this is needed is when a sales order has items from different warehouses needs to be sent to the a sort area ready for packing and shipment.The issue here is that Pickers are assigned to the 9 different warehouses and are not all gathered at one single starting place so the criteria to place path values at each of the particular warehouses Rows, shelves and bins is not possible for the algorithm to do a computation and result in picklist assignment.It seems to me that this leads me to use “manage picking queue” and assign pickers to the picklist where a sales orders items lie amongst the 9 warehouses. However if i do manually assign a picker to a warehouse to

340
A
Freshman II
V
Freshman II
vannakheng66Freshman II
asked in Distribution
Inventory Transaction Summary

when I adjusted quantity + , the adjust value go to received not adjusted columnwhen I adjusted quantity - , the adjust value got to issued not adjusted column

571
Laura02
Captain II
dsimmerly
Pro I
dsimmerlyPro I
asked in Distribution
Historical Sales Order 'Backlog'

If you run the Sales Order Summary Report (SO610500) with no beginning date, the current date as ending and and additional filter of status not equal to complete, you would get a list if all Sales Orders that still need to be filled the their Open Qty and Open Amount.  I would call this the ‘Sales Order Backlog’ or Open BalanceI would like to see this same “Backlog” as of a historical date , say a year ago.  How could this be done? not quite sure where to begin…  thoughts?  

1829
L
Freshman I
S
Freshman I
ScottAtkinsonFreshman I
asked in Distribution
Adjustment Created from Cycle Count Entry

Acumatica is creating a zero adjustment transaction for for cycle counts with no lines adjusted for inaccuracy.  How can I eliminate this adjustment from occurring?

1648
J
Freshman II
claudematherne24
Varsity I
claudematherne24Varsity I
asked in Distribution
Capturing Length, Width and Height at the stock item level - Best Practice

Looking at working on integrations with our shipping broker, and we are investigating how to pass along dimensions for items we ship through them regularly.  I know where is box dimensions that can be captured, but I believe those only come into play during a shipment.  We are trying to store these at the stock item, so that when we create a new stock item that we want our broker’s system to know about, that data is readily available to pull.Does anyone have any best practices?  We are currently looking at either adding the information as attributes, or adding customs fields to the packaging tab on the stock item record.

1162
claudematherne24
Varsity I

Badge winners

Show all badges
Terms & ConditionsCookie 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