Distribution

Inventory, Orders Management, Warehouse Operations

  • 1,330 Topics
  • 5,150 Replies

1330 Topics

alexk95
Freshman II
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.  

4
T
Freshman I
4 months ago
L
Freshman I
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.

8
C
Jr Varsity II
4 months ago
C
Varsity I
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

7
C
Varsity I
4 months ago
P
Freshman I
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 

2
P
Freshman I
4 months ago
rwhetsell77
Freshman I
rwhetsell77Freshman I
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.

3
rwhetsell77
Freshman I
4 months ago
L
Freshman II
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 

2
Laura02
Captain II
4 months ago
K
Freshman II
kevinheng21Freshman 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.

0
K
Freshman II
4 months ago
J
Freshman I
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
H
Pro I
4 months ago
K
Freshman II
kevinheng21Freshman II
asked in Distribution

Prepare Invoice in Shipment

When I prepared invoice in shipment I got this error: Another process has added the 'ARInvoice' record. Please try again.

5
Naveen Boga
Captain II
4 months ago
Michael Hansen
Varsity II
Michael HansenVarsity 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?

10
D
Jr Varsity III
4 months ago
M
Freshman I
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.

8
M
Freshman I
4 months ago
A
Freshman I
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 

5
A
Freshman I
4 months ago
P
Freshman II
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. 

10
P
Freshman II
4 months ago
vivekm
Varsity I
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

4
vivekm
Varsity I
4 months ago
N
Jr Varsity II
NAWRESJr Varsity II
asked in Distribution

Emails and database Size

Hello EveryoneWe have a problem with the size of the database due to the emails and attachements.Is there something we can do in order not to save these emails with their attachements ? a setting we missed?  If not a possibility of a purge of the data we don’t need ?Any ideas Thnx;

13
R
Captain II
4 months ago
H
Pro I
HarshitaPro I
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.

6
H
Pro I
4 months ago
NAthukorala47
Jr Varsity III
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    

3
Chris Hackett
Community Manager
4 months ago
V
Jr Varsity III
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

3
V
Jr Varsity III
4 months ago
S
Freshman I
steph23Freshman I
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?

3
Chris Hackett
Community Manager
4 months ago
A
Freshman I
aidenwills15Freshman I
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!

0
A
Freshman I
4 months ago
kandybeatty49
Captain II
kandybeatty49Captain 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.  

5
Chris Hackett
Community Manager
4 months ago
A
Jr Varsity II
amit61Jr Varsity II
asked in Distribution

HEIC File Type Mobile Upload

We’re running 22R1 and having an issue with users being able to upload images of HEIC file type. We’ve added this file type to the file upload preferences screen and selected the check box for “image”. However, when we try to upload this file type from the mobile app, it says that this file type is not allowed. Anyone have any ideas on what is going on here?

2
meganfriesen37
Captain I
4 months ago
D
Freshman II
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 ?

5
Chris Hackett
Community Manager
4 months ago
T
Freshman II
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. 

6
Chris Hackett
Community Manager
4 months ago
T
Jr Varsity II
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 

6
Chris Hackett
Community Manager
4 months ago

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 — 2023  Acumatica, Inc. All rights reserved