Community
Discussion Forums
Distribution

Distribution

Inventory, Orders Management, Warehouse Operations

1,959 Topics
7,351 Replies

When you subscribe we will email you when there is a new topic in this category

1959 Topics

Recently active

Most replies Most views Newest first

mna10Jr Varsity III

asked in Distribution

assignment a workgroup automatically based on SO type

Hi, Does anyone know a way to auto assign a Workgroup on the SO based on SO type? Right now, we have to manually enter the workgroup when entering that SO type order.

1 year ago

brettd36Freshman II

asked in Distribution

Use of barcode scanner on the mobile app for Sales Order creation

Good day,We have asked this question to Acumatica pre sales and they do not have a defintive answer and say we need to test this process. The current scenario that works is that Acumatica can recommend using Zebra scanners with the mobile app and it works using WMS, however the Sales order process is different and not tested.The client would like to achieve a process whereby they install the Acumatica mobile App onto a tablet or handheld device and then raise quotes and sales orders on the app, when they need to select the item to quote on they want to be able to use that same device to scan the barcode on an item and have that pull in the stock item into the SO/Quote. This would also be true for raising an invoice.They dont want to go the tradtitional route of a POS workstation that stands at a till point with a connected canner device as they require mobility for their sales team.Anyone else with this problem or have a solution?

1 year ago

ltussing03Captain II

asked in Distribution

Shipping screen - Get Return Label

On the more menu of the shipping screen, there is an action labeled “Get Return Labels”.I can find no documentation on what that is supposed to do. Is it supposed to just print a label or does it do anything to data?Also, I get an error saying “Confirmation for each and every package is required.” when I do this to an open shipment. If I have a Confirmed shipment open in the screen, the “Get return Labels” is grayed out and unavailable. Thanks for any insight!

1 year ago

alexk95Freshman II

asked in Distribution

Format Date Field to MMDDYY in A Generic Inquiry

Hello,I am trying to format a date field on the results grid on a GI to be MMDDYY with no dashes or slashes I.e.06/01/2022 should be formatted 060122, is there a way to convert with formatting or function?Any help would be greatly appreciate it.

1 year ago

lorneweinsteinFreshman I

asked in Distribution

Where to see the Physical Inventory history

Does anyone knnow where in the system I might be able to find the history of a physical inventory by item? Is there a report or screen where I can access that or pehaps someone knows the underlying table that I could look at through the DAC browser? Any thoughts would be appreciated.

1 year ago

chidao

asked in Distribution

Sales Orders - Show Lot/ Serial Number

HI All,The Screen Sales Order always shows <SPLIT> on the Lot/ Serial Number Column.There is any way that we can show the content instead of <SPLIT>?Thank you,Yên Chi

1 year ago

patriciabatisti2Freshman I

asked in Distribution

Invoice freight non stock item with last stock item shipped

Hello, I have a client that would like to invoice the non-stock item with the last shipped stock item from the sales order. Currently the non stock item freight is added to the first invoice created for the sales order. Is there a way of control this or do we need a customization? Thanks, Patricia

1 year ago

rwhetsell77Freshman II

asked in Distribution

Can the "Sold Since" date in the "Add Items" window be defaulted for a different amount of time?

I realize that the “Sold Since” date defaults to three months from the current date: Is there a way to default this to a different amount of time? A client may want to go back further, say six months, and not have to change this date every time.

1 year ago

lauracFreshman II

asked in Distribution

Question regarding FIFO inventory valuation method for sales

A client would like to use FIFO for their inventory valuation method. They use Batch control and expiry. I have ticked the “cost sep” on the Warehouse location (they only use one location).When entering a Sales Order however it is only taking the cost of the first receipted qty.Is this the way the system works? I am assuming yes bc at the Sales stage the inventory has not been allocated yet so there is no way of picking up the cost?Regards,Laura

1 year ago

kevinheng21Jr Varsity II

asked in Distribution

Add Custom Report to Acumatica Mobile

When I display my custom report in acumatica mobile phone it show me the error like this object reference not set to an instance of an object. But this report I can run this report in web working properly.

1 year ago

jkasprzyk98Freshman I

asked in Distribution

Multiple Pack Quantities for Purchase and Shipping?

Client sells to Distributors, Chains, Retail Outlets. They can ship the same item in a Pallet, Master Pack, Inner Pack or Each. For the purposes of compliance, they have to provide the weight and dimension of each of the shipping methods, although the UOM on the SALE is EACH. We have Acumatica and Pace Jet and are looking to see if someone has tackled this before and is there a way to best handle this other than attributes?

1 year ago

MichaelhSemi-Pro II

asked in Distribution

How to Print .ZPL files from Android OS

I have a bunch of Android Tablet users who would like to print .ZPL files from a Zebra Label Printer. Usually I use DeviceHub or a .bat file to get this moving, but Android doesn’t support .bat and it looks like DeviceHub isn’t supported either.How do we print .ZPL files to a label printer in the Android OS?

1 year ago

melaniemascato62Freshman I

asked in Distribution

Update IN at Invoice vs Shipment Confirmation

Just updated to version 2022 R2. Previously inventory was automatically updated at time of invoice. Since the update, IN updates at shipment confirmation. Where is this change coming from? And how do I change it back? Thanks in advance.

1 year ago

aahmedFreshman I

asked in Distribution

Adjustments for the Stock item with Lot with Expiry date

Hi, when posting any Adjustment to the Stock Item with Lot/Serial Number and Expiry date, if a user accidently enters a different Expiry date, the system updates the Expiry date on all the stock for that item and set this new expiry date. can this be prevented or tracked so the client can see the old and new dates? Many Thanks

1 year ago

pwills69Freshman II

asked in Distribution

Sales Order Import failing because inventory id cannot be found

Trying to import sales orders but some of the lines have invalid inventory ID’s that do not exist in Acumatica. I still need to import the lines that do but they all fail because of the inventory items that don’t exist. How can I skip invalid inventory line and get the rest of the file to import.The import works if I only import inventory ID’s that are in Acumatica.

1 year ago

vivekmVarsity I

asked in Distribution

How to access Customer User-Defined Field in a new Processing screen View Delegate

Hi Team,I have create a new processing screen and in view delegate trying to access a Use Defined Field value from Customer screen to show on UI and I am using 22.106.0015 build version. I have referred some community posts but not been able to access the defined field value. Below are the samples I have verified:The customer’s user defined field value stored in BAccountKvExt table and in DB able to access it but in code not able to access this table. Access User Defined Field from business logic | Community (acumatica.com) from this community post tried to access using new cache object but that also does not helps. public sealed class SOLineExt : PXCacheExtension<SOLine> { public static bool IsActive() { return true; } #region UsrEmployer [PXString()] [PXUIField(DisplayName = "Employer")] public string UsrEmployer { get; set; } public abstract class usrEmployer : PX.Data.BQL.BqlString.Field<usrEmployer> { } #endregion} public cl

1 year ago

HarshitaCaptain II

asked in Distribution

Complete order in Sales Orders (SO301000) screen

Hello linkies,I would like to have a clarification on the Complete Order option which under More Menu of the Sales Orders(SO301000) screen. I have been trying to modify the status of an order from Open to Completed without creating any shipments.Even when the Completed checkbox is active at the line level, the status of the Sales Order still remains to be Open as shown below: Kindly let me know the use of Complete Order option for the same. Thank you in advance.

1 year ago

NAthukorala47Jr Varsity III

asked in Distribution

Access Rights Update via Import Scenario

Hi, I have updated the Access right via Import scenario. It updated high level access security. Ex. We enabled Funds Transfers as view only, but, system allow us to do the reverse when i open the funds transfer form. Is there any possibility to restrict all the levels at once? Regards

1 year ago

victoravila63Jr Varsity III

asked in Distribution

how create a transfer from sales order

Hello: how create a transfer from sales order, but the item comes from secondary warehouse? Best regards

1 year ago

steph23Jr Varsity II

asked in Distribution

Sales price worksheet error when processing the field UOM

We are trying to extract and update the base sales price using either ‘Sales price’ or in the ‘Sales price worksheet’ then using the copy prices option. When we click on the ‘create worksheet’ or ‘copy prices’ we get the below error:An error occurred during processing of the field UOM value LENGTH Error: UOM 'LENGTH' cannot be found in the system. Please verify whether you have proper access rights to this object.We have tried to change the UOM for the rows with Length but we just get the same error but with the UOM we changed it to mentioned.Any suggestions?

1 year ago

aidenwills15Freshman II

asked in Distribution

Price Multiplier not working correctly

Hello all, The price multiplier does not seem to work when I change the UOM. I have ensured to enable it in the SO preferences, and the item has a value in the price multiplier. Am I missing anything?Item at base UOMItem when UOM is changedPrice settings in SO PreferencesConversion setupAny help would be greatly appreciated. Thanks!

1 year ago

Kandy BeattyCaptain II

asked in Distribution

Default Transfer location

Does anyone know of or have a work around for default locations for transfers? I am talking specifically for automated operations. Acumatica has a default Issue from and Receipt to but there are no other defaults that I can see.

1 year ago

DonGreenFreshman II

asked in Distribution

Item ID Lookup from Sales Order Line

How do I search Inventory ID from Sales Order line to find data contained in respective Item(s) LONG Description and/or Item ID Attribute ?

1 year ago

thanhaimFreshman II

asked in Distribution

Get value each column in tab "DETAILS" screen Bills and Adjustments(AP301000)

Hello expert.How cant I get data field in the “details” tab screen AP301000 below image? How can i fetch data each row? Thank you so much.

1 year ago

TitileGamaJr Varsity II

asked in Distribution

Import Scenario Error When Updating Vendor Payment Instructions

Hi Community, please assist. I have setup an Import scenario to import vendor payment details into the system, However upon import, it imports the first Record and gives me an error for all other records. I have checked the formatting on my file and i think its ok. There is no difference between the first record and all other records. PLease assit. What is it that i am missing

1 year ago

Page 41 / 79

Badge winners

tarashas earned the badge Easy talker
hkabirihas earned the badge Import and Export Scenario expert
aiwanhas earned the badge Acumatica expert
rfrantzhas earned the badge Easy talker
WillHhas earned the badge Easy talker

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Social Login

Login to the community

Social Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.