Distribution

Inventory, Orders Management, Warehouse Operations

  • 1,324 Topics
  • 5,125 Replies

1324 Topics

R
Freshman I
rashmikamudalinayake10Freshman I
asked in Distribution

Issue in Sold Since Functionality of Inventory Lookup in Sales Orders

The “Sold Since Functionality of Inventory Lookup in Sales Orders” seems doesn’t work properly. Any idea how to fix it?(In addition, sometimes the date picker is visible and some times It doesn’t).Used Acumatica version - 22R1Used data set - I100Relevant snaps are attached below:when All items radio button is selectedwhen Sold Since radio button is selected 

3
Julia Lukina
Acumatica Employee
5 months ago
A
Freshman I
ASamson21Freshman I
asked in Distribution

Customer Delayed Payment Count

Hi, I need to have a capability to show how many times the customer has exceeded their credit terms (late payment based on credit terms). Do anyone have any idea how to achieve this?Any help would be highly appreciated.  

3
A
Freshman I
5 months ago
B
Freshman I
bclarkFreshman I
asked in Distribution

Creating GI to Show Back Ordered Items

Hello, My company has a generic inquiry they use to show when items will go on back order at the line item by using this comparison in the conditions tab of the generic inquiry.So we are wanting to see items where the quantity available is less than the quantity ordered. Simple enough. However, the QtyAvail from the InSiteStatus table seems to be subtracting the qty from the order quantity first, then making the comparison. Therefore, we are seeing items on this GI where they may be 400 available and 300 ordered. But the “Qty Avail” in the GI is saying 100 available, because it already pulled the 300 for that order. So it is showing that order on the report, even though that one is good.  Any ideas on how to fix this, or maybe another better way to show items that are going to be put on Back Order?  Thanks!

0
B
Freshman I
5 months ago
C
Freshman II
cdelacruzFreshman II
asked in Distribution

Where does the declared value on a package default from?

Hello,We use Pick, Pack, and Ship in our warehouse to process packages which ship via UPS.Recently we noticed the declared value on these packages is $0.0.Where does the system look for the value? (It would make sense for it to default from the MSRP field in the stock item.)I cannot find a setting/documentation that helps; Can’t imagine that the system expects it to be entered manually every time. Thanks for your help.

6
C
Freshman II
26 days 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
D
Freshman I
DarrenKeegan66Freshman I
asked in Distribution

Print a Sales Order even if the account is on hold

Our setup seems to limit printing a sales order if the account is on hold. Is there a way to change this so we can still print the sales order but not approve it yet?

2
D
Freshman I
5 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
T
Freshman II
travislawsonFreshman II
asked in Distribution

Shipping Pallet Costing

We are not using WMS (yet).  How do you handle shipping pallets and pallet costs?  We have a mix of stock items that are finished goods and BOM-based goods so doing fixed overheads I don’t think would work. We have 7 different pallet sizes we have as stock items since we track inventory on them, cost and if we charge the customer for it.  We also have mixed item pallets so while we know item X is 60 to a pallet, Adding Item A, B, C, D and E may not be 60 to a pallet any more due to variations in size of the box, etc.  With our current system we have 1 stock item pallet.  The sales person enters the sales order, adds the stock items and if we charge for the pallet they enter a price.  When the warehouse picks/ships the order they add the pallet item to the sales order at $0 (unless sales person added it already with a price) and the quantity of pallets used.  That follows through to the invoice and shows the pallet quantity and how much they were charged (if anything). With Acumatica we

4
T
Freshman II
3 months ago
P
Varsity I
podonnell11Varsity I
asked in Distribution

Purchase Price Variance and Inventory Valuation

Hello Everyone,I am playing around with various costing method scenarios in right now. Let’s say I enter a PO for 10 of an item at $100. This item is costed at FIFO. Let’s say the accompanying AP Bill is for $120. I understand there will be $20 going to PPV and $20 going to Purchase Accruals. The cost of the item stays at $10/unit even though the bill was for $120. Is there anyway to retroactively update that item’s cost to $12/unit for this PO/Receipt?   If anyone has suggestions or ideas that would be great. Maybe there is an industry standard.Thanks

2
P
Varsity I
5 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
Michael Hansen
Varsity II
Michael HansenVarsity II
asked in Distribution

Last date an item was Physically Counted

How do I find the last Date an item was physically counted in the system?For example:Item A was counted last on March 10th Item B was counted on February 14thIs there an inquiry like this? If not, does anyone know what data table would hold this information so I can make an inquiry? Thanks Everyone!

2
Chris Hackett
Community Manager
5 months ago
K
Jr Varsity II
krausef77Jr Varsity II
asked in Distribution

Adjusting Unit Price on Sales Order after Shipping but before Invoicing

Hi All, We are the option of adjusting the Unit Price for a Sales Order after a Shipment was created and/or completed. In Sales Order status language in the Status of Shipping/Back Order/Complete.The Invoice won’t be created yet. And the goal is to have the Order and Invoice match up in case of Error on original Price Entry and it going through Approval without being caught. I tried Workflow Adjustments and Graph Extension on the SOOrderEntry Graph but wasn’t able to Enable the Unit Price field. I tried both Cury Unit Price and Unit Price. Any ideas on how to achieve this or is this something that Acumatica just doesn’t allow due to being too risky/invasive?

7
Naveen Boga
Captain II
4 months ago
L
Freshman I
Lindsey23Freshman I
asked in Distribution

Delete or Cancel an Item on a Purchase Request

Hello,How do I delete or cancel an item on a Request in Purchases? I click the “cancelled” check box and it still shows up in selection for a requisition.    

1
kandybeatty49
Captain II
5 months ago
kandybeatty49
Captain II
kandybeatty49Captain II
asked in Distribution

Box barcodes

How has anyone set up box barcodes in Acumatica for shipping? When using the mobile app, it asks you to scan the box when you pack. You can simply type in the box code such as A but the client would like to scan the label for the box. Any thoughts or suggestions?

9
Jeff96
Captain II
5 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
N
nithins17
asked in Distribution

Auto allocate/reserve quantity for sales orders in line details

Is there any way to Auto allocate/reserve quantity for sales orders in line details?

1
H
Pro I
5 months ago
dougmcbride79
Varsity I
dougmcbride79Varsity I
asked in Distribution

Customer Portal: Can the customer complete data fields about specific product purchases

Can the Customer Portal be configured so the Customer can input  a few fields of data about specific products the customer purchased?  

2
kandybeatty49
Captain II
4 months ago
variuxdavid
Freshman II
variuxdavidFreshman II
asked in Distribution

Convert Item from Finished Good to Kit Assembly Finished Good

One of my clients sells magazines. Historically their item MAGAZINESKU was purchased as a finished good from a single vendor who produced the entire item. Now, however, the magazine is being produced by two vendors. One produces the covers (COVERSKU) and the other produces the inside pages (INSIDESKU). These are still sold as the MAGAZINESKU item. What is the best way to go about purchasing COVERSKU and INSIDESKU then assembling them to create the finished good of MAGAZINESKU in inventory?If I was starting from a blank slate, this seems like a clear Stock Kit with Kit Assembly. However, MAGAZINESKU already exists as a Finished Good and it is NOT already setup as a KIT. I do not believe I can simply convert it to a kit. Acumatica Cloud ERP 2022 R1Build 22.114.0029 Distribution EditionThanks, David

3
Jeff96
Captain II
5 months ago
B
bradmestach
asked in Distribution

Multiple Replenishments in a single warehouse for a stock Item

We have a need to be able to put multiple replenishments on a single item within the same warehouse. Our case for it is that our inventory control teams need to be able to deliver an item to a production line (Warehouse) in different locations. We use a Warehouse in Acumatica for each production line. But we can’t apply a replenishment for that warehouse because we have a single item occur multiple times on that production line. So we have to use a 3rd party system to notify our inventory control team to deliver the items to the production line. We would love to be able to no longer use that system but rather utilize the replenishment through transfer feature in Acumatica.  Any suggestions would be great!

0
B
5 months ago
K
Varsity I
kokjietanVarsity I
asked in Distribution

1 Purchase Receipt = 1 AP Bill without individually releasing each AP bill?

Our company often receives one line on a PO across multiple deliveries, requiring multiple Purchase Receipts to complete the line.We would like to ease the AP workflow by using ‘Automatically create AP bills’, but we have found that Acumatica only allows one (unreleased) AP Bill for each PR. Our accountant has to manually find each purchase receipt, click ‘Create AP bill’, release the AP Bill, then move on to the next PR. For hundreds of PRs, this becomes rather tedious.Is there any setting to enable the creation of AP Bills from each PR one-to-one without having to release the AP bills beforehand?Preferably, AP bills would be automatically created each time Logistics releases the PR, then Accounts just needs to batch release using Release AP process. 

2
K
Varsity I
5 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
F
Freshman I
FarhanaM60Freshman I
asked in Distribution

Enable the field (vendorID-Opportunities Detail line)at all times

Version-21.217.0035Hi,am trying to make vendor field always enablei tried by adding workflow to the package and also programmatically written row selected event to make enable 

2
Naveen Boga
Captain II
5 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
K
Varsity I
kokjietanVarsity I
asked in Distribution

Access Rights for PO Receipt lines - Delete but no insert?

Hi,We would like to disable the access to the (+) button for manual addition of new lines in Purchase Receipts. All lines should be linked to a PO.However, we do not want to take away the (x) button for deleting lines, since the Purchase Receipt may require amendments after being created from the Purchase Order.I have not been able to disable the (+) button without also disabling the (x) button, as the Delete access right also gives access to creating new lines. Any ideas on how to implement this restriction?

4
Chris Hackett
Community Manager
5 months ago
T
Jr Varsity II
tommaricle43Jr Varsity II
asked in Distribution

Attaching a Terms & Conditions document to a PO when sent via an Email Template

Client has a 5 page Terms & Conditions for the want to have sent with their PO.  It has word-level formatting which would be time consuming to replicate in report designer.  I tried adding a PDF version of the T&C’s to the email template but it doesn’t carry over when I send a PO out of the system using that template.Outside of writing the report does anyone have an easier method of attaching a document to a template that isn’t a report?  

1
manikantad18
Pro I
5 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