Community
Discussion Forums
Distribution

Distribution

Inventory, Orders Management, Warehouse Operations

2,034 Topics
7,620 Replies

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

2034 Topics

Recently active

Most replies Most views Newest first

clancourFreshman II

asked in Distribution

Process Shipments - Update IN-Confirmed Not Billable action removed in 2020R2+

Customer upgraded from 2019 recently and the highlighted item below “Update IN – Confirmed not billable” is what he used to select when processing sales orders that did not need to be billed (such as when you send out a sample shipment to a customer). Does anyone know if this has been replaced or why this is no longer there? Is there another way to have these items selected when processing shipments?I confirmed it’s in 2020R1, not in 2020R2. Nothing in the initial release notes for 2020R2.D100 training references it 2020R1 as well, and not in 2020R2. Oddly enough, the documentation still mentions the action: “Update IN - Confirm Not Billable: To generate inventory documents for shipments made for transfer orders and returns with replacements.”Thx!-Chad» Screenshot from 2020R1

2 years ago

NAthukorala47Jr Varsity III

asked in Distribution

Need to create PO using multiple PRs

Hi, We need to create Purchase Order using Multiple Requisitions. Ex: Need to create Purchase order as Follows. Need to orderItem A from PR-No 01 and PR-No-02 =150 QtyItem B from PR-No 01 and PR-No-02 =210 QtyHow can we merge multiple PRs in One PO? RegardsNethupul

2 years ago

JEFSMIFreshman I

asked in Distribution

Field Above or Below Child Grid

I have a custom screen that has a parent/child standard editing form similar to sales orders in how it looks.Under the child grid or above it, I'd like to put a control that is bound to the same table/field as the child grid.It works to show the initial record's value from the child grid, but as I select different rows in the child grid it doesn't refresh with the proper values. It always shows/edits the first value from the grid. Is there any way to get the control to show the right value from the grid and work like this?I realize I can put in the edit mode for the grid, but for ease of use this one field (multi-line HTML Editor) really needs to just allow the user to click on the row and edit the value easily. Edit: Sorry this somehow posted to distribution. Should have been in Customizations but I can’t figure out how to move it!

2 years ago

dougmcbride79Semi-Pro I

asked in Distribution

Manually updating Last Cost: Should we?

We need help with the workflow on changing the cost price of a SKU. We have been manually updating “Last Cost” as the way we change the cost price of a SKU. Is this correct way to update the cost price of a SKU? If it is not the correct way to update the cost price of a SKU, what is the correct way to change the price?

2 years ago

abdiJr Varsity III

asked in Distribution

API Create Sales Order Return reponse "Not Enough Qty Available, Qty Available Will Go Negative!"

Hello all, please help me.I try create SO with API but response always Not Enough Qty Available, Qty Available Will Go Negative!, i try again with another InventoryID but response is same.I try create SO in Acumatica and worksi try in Acumatica Cloud ERP 2021 R2 Build 21.205.0063

2 years ago

MaracujaFreshman II

asked in Distribution

Bug while saving customer orders: Another process has added the 'PTSOOrderTextElements'

Dear all,somehow I suddenly get an error everytime when I try to save a new customer order…as a result of this error the whole customer order is gone...this is the message I get when clicking saving: “Error: Another process has added the 'PTSOOrderTextElements' record. Your changes will be lost." At the beginning it all worked fine. Then I tried to setup the product configurator...but I do not think that this might be the cause for this problem...Can anyone help?

2 years ago

shmaryarichlerFreshman II

asked in Distribution

Lot/Serial number disappears

I am trying to post a Sales Order type IN. I enter the line information, ie the inventory-id, location, quantity etc. I enter the lot/serial number. When I click plus to enter a new line the system erases my lot/serial number. I don’t know what I am doing wrong.

2 years ago

NoahSemi-Pro I

asked in Distribution

What's the difference/purpose "Include in Qty. Available" and "Sales Allowed" for Warehouse Locations

We’re finally starting to get a handle on Availability and Alloctions...I think We have a DEMO location with items we do not want included for normal Sales operations, but do occasionally ship to customers or distributors. Unchecking the “Include in Qty. Available” is a necessity since we do not want these items to be considered as available for normal Sales Orders. However, with “Sales Allowed” still checked, we can add the items from that location to a Sales Order, but we cannot create a Shipment. The documentation says this:Include in Qty. Available A check box that you select if the quantities of goods available at this location will be included in the quantities of available goods and used in shipments and transfers. Sales Allowed A check box that you select if only issues (direct inventory issues as well as the issues generated from sales orders) are allowed for the location. You clear the check box if no inventory transactions are allowed for this location, except for i

2 years ago

Jp89

asked in Distribution

Can Landed Costs (e.g. levies that are %) be auto calculated upon products received from a supplier?

2 years ago

FarhanaM60Freshman I

asked in Distribution

Version-21.115.0017

Hi,I have done Custom in Purchase Order ScreenIn POLine level am trying to update Curyunitcost according to InventoryID -(Stock Item screen-Valuation Method-Specific)equal to 0it is updating but in header order total is updating with the price cost which is defined in stock items screen..From Where it is getting updating am not knowing..Please Suggest me with the Proper solution

2 years ago

PorchlightZachVarsity II

asked in Distribution

ShipEngine ShipVia not working after upgrade from 2019R1 to 2021R1

When my company went live with Acumatica in 2019 we were given access to a preview release of the carrier integration for ShipEngine. Last week upgraded to 2021 R1 (v21.117.0037) which includes this feature out of the box. Before the upgrade I unpublished all customizations and did not republish the early release version we had been using. Before this upgrade everything was working for us as expected between Acumatica and ShipEngine.After upgrading to 21R1 I had to modify our carriers to use our ShipEngine Account ID instead of the API Token that the preview release required. After that change the Test Connection button on each carrier reports success. However, when I edit a ShipVia based on one of these carriers the service method selector no longer loads in any of the services tied to our account.Due to this configuration issue, we are not able to successfully refresh rates or shop for rates from sales orders. We are able to create shipments successfully with update 17, so I d

2 years ago

max21Freshman II

asked in Distribution

Required Reason Codes for discounted SO Lines

Hello, We want to track transactions that are discounted, due to a misprint/reprint (we decorate our products). I’m assuming Reason Codes on the SO Line is the best way to track this, but please suggest any good alternative ideas. Is there a way to make Reason Codes required for discounted SO Lines? Our users will forget to input a code unless we require it.

2 years ago

ray20Captain II

asked in Distribution

Maximum Order qty/ Order qty limitation on Sales order line

Hello, Does anyone know is there a way to set Maximum order qty for a certain item on order line?Like we are having item A, item A is a hot sell item, so we want to set a limit that each order can only buy 3 at maximum. Is there a way to do it?

2 years ago

mylescarroll22Freshman I

asked in Distribution

Inventory Balance Report not including certain items.

We’re using a slightly modified Inventory Balance report. Some items are being excluded from the report. Only common denominator I can find is these items all appear to show ZERO QUANTITY ON HAND and ZERO AVG COST. But I can’t figure out why that would exclude them. Like I said the file is modified from the original, so I’m attaching it here. TIA!

2 years ago

nancyyymagdy01297Freshman I

asked in Distribution

Quality Control/Check

I need to inquire about the do ability of having Quality Control or Check in Acumatica new version 2021 R1

2 years ago

rodrigocid34Varsity II

asked in Distribution

Access rights for an attribute list type value

Hi!If I have an attribute list type and I'm using it as an UDF within Sales Orders and I want to limit access to one of the attribute value for specific users, is it possible?Thanks!!

2 years ago

abdiJr Varsity III

asked in Distribution

How to remove Quantity Control in Shipment

i want remove Quantity Control in Shipment Screen, is there a setting for that?

2 years ago

Nelson YipJr Varsity III

asked in Distribution

Spot Inventory Counting

Is it possible to use the Mobile App and perform a spot inventory counting.Such as using the inventory lookup tool on the mobile app.Then going to that location and update the inventory on the fly?

2 years ago

Nelson YipJr Varsity III

asked in Distribution

Inventory with Handheld Scanner

Is there a way to do a spot inventory count without creating any Physical Count sheet.Walk up to the bin location and scan the the location, then the bar code and then enter the quantity.

2 years ago

stacy16Varsity I

asked in Distribution

Cycle Counts

I am looking to do cycle counts on our inventory however I don't seem to have the box to check on the stock items screen.. Anyone else having this issue?

2 years ago

nsmith51Jr Varsity III

asked in Distribution

Sales Order Screen - Pricing Analysis should not show the Zero cost items

Hello Everyone,One of our clients using the Pricing Analysis functionality in the Sales Order screen, but we do not want to show the Zero unit cost items on it.If anyone knows about this functionality could you please let us know how can we achieve this? Please find the some screenshots for your reference.

2 years ago

MichaelTobiJr Varsity II

asked in Distribution

Is There a Method to Setup Cost + % Pricing?

Hi,Is there a way to setup cost + % pricing based on the Vendor Price that’s setup in the system?The only way I can currently think of to do this is to come up with a price file on Excel outside of Acumatica and import it through the Sales Price Worksheets for a specific customer. Are there any limitations on that screen in terms of # of rows? We need to set this up for approximately 10,000 items.Thank you!

2 years ago

csilvestri15Freshman II

asked in Distribution

Increase Qty on Shipment

Is there a way to increase the qty shipped on a shipment record without first having to edit the original sales order?

2 years ago

rosenjonSemi-Pro III

asked in Distribution

How to have PXSelector show default value?

This is a follow up to this one: How do I make my default value for my second UOM selector appear in the selector on page load?Here’s my DAC declaration. I also used the strategy in the referenced link to set the values for the selector dropdown on load.I added this to try to get the default value to display...but it didn’t work: [PXUIField(DisplayName = "jUOM", Visibility = PXUIVisibility.SelectorVisible)]I also tried a few other things that didn’t work. Any thoughts on how to get a Default value to appear in the Selector at load?This part of the below referenced DAC should load the default, I think, but it doesn’t work… [PXDefault(typeof(Search<InventoryItem.salesUnit, Where<InventoryItem.inventoryID, Equal<Current<SOLine.inventoryID>>>>), PersistingCheck = PXPersistingCheck.Nothing)] #region juOM public abstract class juOM : PX.Data.BQL.BqlString.Field<juOM> { } protected String _jUOM; [INUnit(typeof(SOLine.i

2 years ago

EvanGVarsity I

asked in Distribution

Inventory: Remove stock amounts; no transactions

I have a need to remove the current quantity from item stock. The quantity were incorrectly imported. This tenant has been inactive. We have sales or purchase transactions. What is the best or easiest why to zero out the quantities. I was thinking of doing an inventory adjustment or use the physical count. There are financial issues since the tenant has not transaction. The amounts were imported. I appreciate any assistance or advice on the best way to handle this issue.

2 years ago

Page 72 / 82

Badge winners

chameera71has earned the badge Distribution expert
michelle76has earned the badge Easy talker
DavidEichnerhas earned the badge CRM expert
wanizaidi27has earned the badge Easy talker
stephenbologna39has earned the badge Integrations and Web Services | APIs expert