Skip to main content

Distribution

Inventory, Orders Management, Warehouse Operations

  • 2,373 Topics
  • 8,817 Replies
2373 Topics
M
Jr Varsity II
mpowellJr Varsity II
asked in Distribution
Credit Card Sales Order Fee

When a customer decides to pay using a credit card, we charge an additional 2.5%. Is there a way to increase item cost by 2.5% when payment type CC is selected? I see where we can offer cash discounts by days but not an increase by term type. If not, I plan to create a Non-Stock item “Credit Card Fee” where we can calculate the 2.5% manually and add it to the order. 

9032
T
Jr Varsity II
jesuscruz97
Jr Varsity II
jesuscruz97Jr Varsity II
asked in Distribution
Landed Costs - Type VAT Taxes

Does anyone know how the Landed Costs with Type - VAT Taxes work?I want to know how to configure and how it works. Thanks Jesus 

2268
C
Semi-Pro I
J
Freshman I
jennifer39Freshman I
asked in Distribution
How can I add Alternate ID in PO Receipt Line?

Hello There,I wanted to see alternate ID on PO Receipt line, how can I do this?Thank youJennifer

3493
Naveen Boga
Captain II
R
Semi-Pro III
rosenjonSemi-Pro III
asked in Distribution
Supplying Inventory Balances For Testing Purposes

Does anyone have thoughts on how I might supply inventory balances to the system externally without having to manage inflows (Purchase Receipts) and outflows (selling stock from the warehouse)?As we test transitioning from our old system, we’d like to use the balances from the old system but allow the new system to enforce order limits, etc.I’m guessing this is not a thing, but I’m curious if anyone has any clever tricks to make this work...

475
Kandy Beatty
Captain II
M
Freshman II
MalgorzataFreshman II
asked in Distribution
Outside processing without manufacturing mode

I would like to ask is it possible and how to set outside process (outsourcing) without manufacturing mode. Till now I found solutions only for manufacturers by creating Production Orders but what if there is no production onside and we ship a purchased item to the Vendor for an outside process (coating etc) and then afterwards we receive it back from Vendor ready to sell. How to organize that case in the system in order to calculate costs correctly and track the item?

3642
R
Freshman I
P
Semi-Pro II
podonnell11Semi-Pro II
asked in Distribution
Scan and Transfer Different Warehouses

Hello everyone, I am playing around with the mobile app with warehouse management. I am trying to use the scan and transfer function to transfer between warehouses but the scan and transfer function seems to only allow transfer between locations in a single warehouse. Is there a way to bypass this? Is there any work-around? Thank you

2932
P
Semi-Pro II
M
Jr Varsity III
michael73Jr Varsity III
asked in Distribution
Block all actions after Confirm Shipment on the Shipment screen

2 of our customers have asked us to hide the Update IN and prepare invoice screen on the shipment screen.I tired to do this with permissions but am not well versed in it. After some research, it looks like I will need to do it through a custom work flow.Is this the right way to do this? Can I tie different workflows to specific roles? If not, do I just create a new screen based on it, add it to the site map and tie that to the role?All advice appreciated and thanks in advance.

2884
M
Jr Varsity III
Chris Hackett
Community Manager
Chris HackettAcumatica Community Manager
posted in Distribution
Community Meetup - Distribution Show & Tell: Side Panels - Tue, Mar 15, 9:00 AM - 10:00 AM PT

Engage with other Distributors in the Acumatica Community with the new Distribution Show & Tell where Acumatica customers, partners, and Product Management staff share different ways they use Acumatica, sneak peaks into upcoming features, discussions around vertical markets, and trends in the industry. Each meetup will have a topic with individuals prepared to share, time allotted for participation from others who have joined, Q&A with each person who has shared, and polls on various topics to get your feedback. Show & Tell will be informal and interactive, so come ready to share your camera and engage: participate in the discussions or just listen in. The first Distribution Show & Tell topic is SIDE PANELS, one of my favorite features of the Acumatica platform. See how Acumatica Community members have used side panels to track shipments, view PDFs, see if the Finished Good on the SO can be fulfilled on the requested date (exploding a BOM into multiple levels), and much

220
Chris Hackett
Community Manager
Y
Semi-Pro I
yisroel39Semi-Pro I
asked in Distribution
Mobile Sales Order Add Stocked Item

Hi, I’m trying to add the Add Stocked Item popup to the mobile sales order (SO301000). I had success add the list of items (InventoryLookup), however I want to add the filters and its not working.I’m trying to follow the documentation https://help-2020r1.acumatica.com/(W(4))/Help?ScreenId=ShowWiki&pageid=7244493f-a03a-4efa-9cef-18f2d4f08682 RedirectToContainer="InventoryLookup$List$InventoryLookupInventory" update screen SO301000 { update container "OrderSummary" { add recordAction "AddInvBySite" { behavior = Void redirect = True redirectToContainer = "InventoryLookup$List$InventoryLookupInventory" } } add container "InventoryLookup" { visible = False fieldsToShow = 6 listActionsToExpand = 2 formActionsToExpand = 3 containerActionsToExpand = 2 type =SelectionActionList add field "InventoryIDInventoryCD" add field "QtySelected" add field "Description"

2472
R
Varsity III
D
Varsity I
DanielStarkeVarsity I
asked in Distribution
Creating Draft Purchase Receipts to track incoming international stock

I would like to know if there is a way to create draft purchase receipts to track incoming stock. I have attempted to use the Purchase Receipt form but the problem with this is that the moment stock is on a receipt, even if that receipt is on hold, it shows as “Available” in the stock inventory summary and in some stock views.If it were possible to do this it would be an ideal place to store the transit documentation such as the Bill Of Lading and Customs documents and it would be even better if we could somehow use it to give insight/visibility internally on when stock is due to arrive on a line by line basis via a custom GI. Thoughts, comments and suggestions will be much appreciated.  @Naveen B  @Chris Hackett 

653
D
Varsity I
M
Freshman II
mbrunerie43Freshman II
asked in Distribution
Limit to the use of variants in matrix objects

Hello, One of our customers has the following problem: he wants to use the creation of matrix items with only 2 attributes: sizes and colors, for which he has respectively 400 possible size values and 4500 possible color values. When he uses the grid in the template screen for matrix items, it simply can’t be loaded and he can’t use this functionality. He doesn’t want to break down the number of possible values in his use case. I have tried this myself with 200 values for 2 attributes, and indeed the time to check a box in the matrix item creation grid, takes at least 5 seconds before I can check another one. Have you ever encountered this kind of situation? Would you have an idea how to handle this request? Customization project or other?Thanks in advance for your feedback! Have a nice day!

1814
M
Freshman II
K
Jr Varsity II
kudzaim20Jr Varsity II
asked in Distribution
Custom sales invoice listing report how to differentiate a credit memo from an invoice

I have a custom sales invoice listing report with a column for invoice type. I would want to know I can I add a negative sign to my invoice type “credit memo” so as to differentiate them from invoices?

1613
K
Jr Varsity II
K
Jr Varsity II
kudzaim20Jr Varsity II
asked in Distribution
Adding Inventory cost price to custom Material Usage report

Good dayI have a custom Material usage report I built based on a copy of the standard Historical Inventory Balance report. I am using the “Assembly Out” column which is my consumption as I only work with Assemblies. On the same report I would want to add a column depicts the current or historical material cost of an inventory item. I have tried to add the Last Cost field from the InventoryItem table but this does not bring any results.What method can I use to have the cost price field reflecting the item cost on the report?  

560
K
Jr Varsity II
T
Freshman I
trisnosumardi87Freshman I
asked in Distribution
waiting approval for back order Status

when Sales order not using approval setting, how to solve a back order status in sales order turn into waiting approval if the user change any of the column in detail line ? because approval action is not working..thx

1337
deebhane
Semi-Pro I
N
Jr Varsity III
Nelson YipJr Varsity III
asked in Distribution
Default Qty while entering Quote / SO entry

Hello, Is is possible to change the default qty from 0 to 1 while entering line items during quote or sales order entry.  This will speed up the process due to most line entry is only quantity of 1.Thanks

6836
R
Semi-Pro III
J
Freshman I
john25Freshman I
asked in Distribution
Acumatica is showing a file attachement but none there.

We use the drag and drop file attachemnts to add the customer PO to the SO.In some instances it shows a file in the SO but the file box is empty.What could cause this?ThanksJohn 

2274
K
Freshman II
NAthukorala47
Jr Varsity III
NAthukorala47Jr Varsity III
asked in Distribution
How to Update the Item Cost under FIFO basis costing

Hi, We need to update the Item Cost base on the FIFO cost method. Ex. Item A - 20 Qty with 10$ After add the Laded Cost Value for particular Item Cost, it would be 12$. Have there any possibility to update the Item cost manually? Since user already has completed the landed cost process without adding additional 2$.Now we need to update that additional 2$ to Item. RegardsNethupul  

8486
Chris Hackett
Community Manager
S
Freshman I
scottz38
asked in Distribution
Expiration Date Tracking Without Lot Tracking

We have hundreds of items that require Expiration Dates annually. When an Item gets close to its Expiration Date we must have the product Re-Tested. Is there a way to track Expiration Dates without enforcing Lot/Serial Tracking on items? 

5177
Chris Hackett
Community Manager
A
Freshman I
annekseymourFreshman I
asked in Distribution
Import Scenario - Zip Code String

I have created an import scenario for orders, but the international orders will not import.  How / what code do I need to use to allow the international zips to load (alpha numeric) and then to have Hong Kong default to 00000 (they don’t have a zip code) .This is what we are using now:  =IIf(( Len([bill-postal-code])=4), ('0'+[bill-postal-code]),(Substring([bill-postal-code],0,5)))

4817
M
Jr Varsity II
M
Freshman II
mcovic70Freshman II
asked in Distribution
UPS Smart Shipment Mapping Errors

This client has recently started having an issue where when they import Acumatica shipments into UPS Worldship, the shipment number from Acumatica fills into the zip code in UPS Worldship. Has anyone else seen this?

410
M
Freshman II
L
Freshman I
LAWFreshman I
asked in Distribution
Change a UOM of an existing Stock Item

We would like to change a Unit of Measure UOM of an existing stock item from EA to FT (Foot).  We want to learn the proper procedure to do this.  I trust there is a simple process for this.  Please advise.

15973
L
Freshman I
david41
Jr Varsity II
david41Jr Varsity II
asked in Distribution
Physical Inventory Adjustment splitting adjustment to wrong sub account

Hello, we have an issue where we posted a PI and there was an item that was being adjusted down by a qty of 13 in the warehouse and was entered on a single tag.  In the adjustment that was posted this was split into 2 lines for a qty of 10 and a qty of 3.  The 10 booked to the correct sub account but the 3 went to a default sub account. We have it configured to use the sub account at the warehouse setup for inventory transactions.  The items do not have locations and are not serial or lot and we are using average cost.This happened on about 10 items out of 300 total counted items.I can’t determine why those 3 booked to the default sub account rather than the correctly mapped one.

840
david41
Jr Varsity II
NAthukorala47
Jr Varsity III
NAthukorala47Jr Varsity III
asked in Distribution
Need to Make Project wise Approvals for Purchase Requisition

Hi,  We have attached Approval Process Flows to build.    Following Points need to be considered. (01).  Considering One Project, there are 3 Employees are fixed.         Ex: Level 01-  Quantity Survey Approved then Transfer to Project Manager or Site Manager(Parallelly Approval). This staff only responsible for One project.(02). Head Office QS is Responsible for multiple Projects.(03).  Divisional Heads also responsible for Multiple Projects.(04). Then AGM and Two Parallelly Approval Level.  Need to Build the Approval Logic for Purchase Requisition.  RegardsNethupul    

770
NAthukorala47
Jr Varsity III
suppal19
Freshman II
suppal19Freshman II
asked in Distribution
Pick Pack Ship Help - Client has work flow issues with how Acumatica deals with shipping?

 Good Morning Forum Members,We are currently in an implementation with our client. I have reached out to support and escalated the issue, but unable to get a sufficient response for the client. They have several process work flow issues with how Acumatica handles shipping. These are some concerns they have with Pick, Pack, Ship features:What happens if they are picking an order into totes and the tote is full? The Pick, Pack, Ship screen requires the user to enter a tote ID for each shipment in the picklist. However, when that tote is full, can the user scan another tote ID for the shipment?Can multiple picklists be shipped together?Can we re-open a package to add additional items? Once confirmed, is there a way to re-open packages to add additional items?Are they able to combine shipments after the picking is done? Thank you in advance, I would really appreciate some insight on this process.   

6923
Dana Moffat
Acumatica Moderator
E
Varsity I
EvanGVarsity I
asked in Distribution
Business Accounts "Mass" removal of Duplicates/Fathom accounts

Good afternoon,i have a mess to clean up with integration that created multiple fathom business/customer accounts with the same name but a different account number.  They created when the integration went out of control.  Now, i need away to clean up and delete these  business accounts/ customer profile.  Any suggestions?  Import Scenario?  I don’t want to manually have delete them.Thank youEvan

3548
E
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