Community
Discussion Forums
Distribution

Distribution

Inventory, Orders Management, Warehouse Operations

2,027 Topics
7,608 Replies

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

2027 Topics

Most replies

Recently active Most views Newest first

kokjietanSemi-Pro II

asked in Distribution

Calculate local carrier Freight Cost by No. of Packages?

Hello,Would like to inquire - is there any way of calculating the Freight Cost of local carriers by the number of packages on the Sales Order?Eg. each box = $15 freight cost, if the SO is to be auto-packed in 10 boxes, the freight cost should become $150.So far, I have only been able to calculate the Freight Cost by weight (per unit) or per shipment (net) for local carriers. Whereas our carriers charge directly based on packages, not weight.

1 year ago

JSager76Jr Varsity II

asked in Distribution

Reverse kitting

I’m not sure if I’m terming this correctly, and I’m also not sure if this is addressed in purchasing/receiving or if this is separate and is more of a kit consideration.We are a service company. The scenario is that we purchase an item from a supplier, but sell the items components as separate items in our system. My thought would be to create a “reverse” kit that can be “assembled” to negate the purchased item and increase the component count, which is the opposite of the normal assembly process for non-stock kits.For example; We purchase a repair kit/item from a supplier, which contains a bolt and a bracket. We will receive the item, however we want to stock the components as inventory. We will then use/invoice either the bracket, or the bolt, or both, however those pieces will be invoiced as separate items.Any thoughts on how to make this work in Acumatica 2022r2 (or beyond)?

1 year ago

jhouserPro III

asked in Distribution

Inventory Transfers not received GI?

I’m trying to create a GI (for a dashboard) that lists Inventory Transfers that have not been received. I’ve used my imagination and looked at tables in the DAC browser, but haven’t found what I’m looking for. Anyone have something to share? :)

1 year ago

kokjietanSemi-Pro II

asked in Distribution

Landed Cost - An error occured during the processing of the field UOM

Hi,We are getting this error when we try to add Landed Cost to this Purchase Receipt. The error occurs both when triggering the ‘Enter Landed Cost’ button directly on the PR, and manually adding the PR to the Landed Cost document.Our landed cost settings work well for other receipts, it’s just this PR which currently is triggering the error.There is sufficient stock in this warehouse of the same lot/serial and inventory ID, and no issues since the original receipt. The UOM still exists on the Stock Item. I can use the B900KG UOM in inventory transactions and new POs without issue.Anyone have any ideas on how to get the LC working?

1 year ago

Fie

asked in Distribution

Adjust decimal place in Stock Items Conversion

Hi Acumatica Community,Seeking your assistance with my concern,Currently the Stock Items Conversion is set up to 6 decimal place. In the Companies Screen, I already change this into 3 decimal place in which I wanted to appear.But it is still the same.. (no effect)Do you have any suggestion for my concern?Thank you!

1 year ago

amitkaryekarJr Varsity II

asked in Distribution

Receive Goods Via Scanning Application or stocktaking without a cross reference barcode field

Hi All, We have a unique need where our customer doesn't want to fill out the import templates for barcodes as these 10-16 digit barcodes for thousands of items are quite unrealistic as they are moving from paper based. Is there any way in acumatica where items with the these barcodes can be scanned ad hoc in the system without having a cross reference to start with either via purchase order or stocktaking. I will wait for any suggestions if any please.

1 year ago

Fie

asked in Distribution

Approval Maps : Cury ID

Hi Team,Seeking your assistance for this concern.I tried to add a new condition in approval maps in Acumatica but upon savings this error appear. By the way We add some branches and this error appears.Thanks !

1 year ago

phillipmarottaFreshman I

asked in Distribution

Zip Code Entry to populate the City, State and Country

When a user enters in a Customer, Vendor, Contact, Ship to Address, (anywhere where the zip code is part of the address); the user would like to enter address line 1, zip code, and then have it auto populate the City, State and Country. We are converting a client from Sage and they are showing how the process works.

1 year ago

RaphaelPfaff12

asked in Distribution

Edit Scan Message in Screen Pick, Pack, and Ship (SO302020)

As a user, I would like to see not only the item ID in the scan message, but also the description. Does anyone know how to extend this? Unfortunately, I did not find anything in the attributes of the Message field.

1 year ago

victoravila63Jr Varsity III

asked in Distribution

Replenishment

Hello: I would like to know if you have an example of how to carry out the replenishment having a general store that buys, for all the branches, but each branch has its own safety inventories, reorder points and that its method of replenishment for the branches is by transfer.For my part, I configured it but the demand in the branches is not recalculating, hopefully they have some support material.Thank you very much and greetings

1 year ago

lmayse38Freshman I

asked in Distribution

How do I keep Payment Ref. field available when creating a Quick Check?

1 year ago

parveza33Jr Varsity III

asked in Distribution

Import scenario to Update Sync field in BOPIS Store to Sync (ECommerce)

Hi TeamLooking for an Import scenario to update the Sync field on the ‘BOPIS Store to Sync’ grid.Thank you.Screenshot for reference

1 year ago

chenwmJr Varsity II

asked in Distribution

How do we issue purchase return for dropship PO?

We have a dropship PO which associated with a Sales Order. Basically we have released 1 purchase receipt and AP bill for the dropship PO. The Sales Order which associated with the dropship PO is completed with invoice.But unfortunately, we accidentally released another purchase receipt for the dropship PO which is not supposed to be.How do we make correction for the wrong receipt?

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

Fie

asked in Distribution

SO TR ( Invoice Status)

Hi Acumatica, Upon clicking of Prepare Invoice in SO with TR Type. The Invoice Status is already balance though the on hold check box in AR Preferences is enable. Is there a way to make it on hold? So that our approval for invoice might effect. Thanks !

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

FarhanaM60Freshman I

asked in Distribution

Prepare Replenishment Data View Override

Hi ,Version -22R1Added one Custom Ware house Selector Client wants to Change the Custom Selector of Warehouse When he changed the Selector Value According to the value in the Detail level three fields data has to change Tried Modified data view using delegate but it is not affecting and tried writing code in Row Selected event then also it is not working please suggest me with the Solution INReplenishmentFilterExt ext = filter.GetExtension<INReplenishmentFilterExt>(); if (filter.ReplenishmentSiteID != ext.UsrPurchaseWarehouse) { foreach (INReplenishmentItem item in Base.Records.Select()) { INReplenishmentItem Rep = PXSelectJoin<INReplenishmentItem, LeftJoin<INItemClass, On<INReplenishmentItem.FK.ItemClass>>, Where<INReplenishmentItem.siteID, Equal<Required<INReplenishmentItem.siteID>>, And2<Where< Current<INReplenishmentFilter.ite

1 year ago

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

jclarkFreshman I

asked in Distribution

Holiday ship dates

Can holdiays be blacked out when putting in an order so that we do not have a ship date of a date we are not in the office?

1 year ago

HarshitaCaptain II

asked in Distribution

Sales Prices & Sales Price Worksheets in Acumatica

Hello Community,Was getting a bit confused between the flow for Sales Prices (AR202000) & Sales Price Worksheets (AR202010) screen. How shall a user start with the same? Is it first from Worksheet to Sales Price or Adding a price line, creating a worksheet from the Sales Prices form and then releasing it in Worksheet screen,Kindly guide me out in the same.Thanks.

1 year ago

HarshitaCaptain II

asked in Distribution

Overseas Shipment

Hello Community,I have a scenario where the prospect not only does the local shipments but also does shipping of the items overseas. Was wondering how can we record the overseas shipments in Acumatica.The flow is like: SO→ Shipments forwarded to forwarding agencies (with invoice & packing list) → Customs Clearance → Delivery to the overseas customer.Thanks in advance.

1 year ago

andy99Freshman I

asked in Distribution

Shipping integration tool with UPS and acumatica

Has anyone had an issue with acumatica pulling all the info from UPS back into the shipment with the shipping integration tool? I’ve noticed that when I get a shipment that has at least 10 boxes/packages, it won’t pull all the tracking numbers back into acumatica and the shipping cost has to be adjusted as well because its only pulling the cost of the boxes pulled back into the shipment in acumatica.

5 months ago

jenjen98Freshman I

asked in Distribution

Non-Stock items - Alternate ID - Cross Reference

When entering a PO or vendor invoice, I would like to use the Alternate ID that is referenced below. I was under the assumption that this was possible, but when trying it out I receive ‘No Results’ when typing OW092 in the inventory ID. Any thoughts would be appreciated! Jenny

1 year ago

Fie

asked in Distribution

Non Stock Items in Kit Assembly Transaction

Hi Acumatica,I tried to transact a kit assembly with a non stock items components.The Non Stock Item GL Set up is this.but when i post this kit assembly it gives me this entry. The question is why is it Cr. Inventory Account? Is there a set up for this? To control the Cr. Entry upon releasing of a particular kit? Thank you!

1 year ago

ray20Captain II

asked in Distribution

Freight Price based on invoice amount only count stock items

Hello, We are using “shipping terms” to charge some specific customer handling fee of 2% of item sold. Normally, it would be fine. But this Invoice amount would contain “non-stock or service” item, which should not be charged. How can we just count the freight price based on ONLY sotkc items?

1 year ago

Page 52 / 82

Badge winners

stephenbologna39has earned the badge Integrations and Web Services | APIs expert
pankaj65has earned the badge Easy talker
PatrickBaconhas earned the badge Easy talker
Dipak Nilkanthhas earned the badge Financials expert
kkraushas earned the badge Easy talker