Community
Discussion Forums
Distribution

Distribution

Inventory, Orders Management, Warehouse Operations

1,967 Topics
7,392 Replies

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

1967 Topics

Recently active

Most replies Most views Newest first

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

1 year ago

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

1 year ago

steph23Jr Varsity II

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?

1 year ago

aidenwills15Freshman II

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!

1 year ago

Kandy BeattyCaptain 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.

1 year ago

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 ?

1 year ago

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.

1 year ago

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

1 year ago

jhouserPro I

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

kyle90Varsity II

asked in Distribution

Enter Landed Costs and Pay AP Bill Prior to PO Reciept?

From my brief research and testing it would not appear that Acumatica allows for a workflow where Landed Costs can be entered and paid for prior to the purchase receipt. Has anyone figured out a way to accomplish this cleanly? Like many companies, we are importing items from overseas and paying some significant landed costs in the form of freight and duties. We want to capture these costs and apply them to our item costs, but often we need to pay bills before items are received. Neither the freight companies or the brokers are interested in waiting for us to receive the inventory before they get paid and I imagine this is a very common scenario - is this a simple oversight in the Acumatica functionality? or have I missed something obvious? Appreciate any insight others have in this area

1 year ago

nbnexFreshman I

asked in Distribution

Sales Order: automatically check "Mark for PO" if stock is negative

Hello,is there a way to automatically check the “mark for PO” checkbox in a sales order if the entered quantity will result in a negative stock qty? The sales staff tends to forget to check the box every now and then. I am looking for a way to make sure no items from SOs are missing in our POs. thanks for your help.

1 year ago

cwomack98Jr Varsity III

asked in Distribution

Kit inventory report

Looking for a report or GI that would show available inventory for components of a kit. I can’t seem to locate anything like that but it sounds familiar. Am I missing something or does this not exist? Original question from client: I want a report that shows my available inventory on hand for all the components in a kit, all on one report.

1 year ago

umeshramaswamy82Jr Varsity III

asked in Distribution

Landed Cost paid before PO Receipt

We have a situation where landed cost needs to be applied before PO Receipt and landed cost is paid before receipt. Landed Cost Vendor is different from the PO Vendor. Landed Cost paid is to be linked to the PO. Acumatica does not allow Landed Cost creation before PO receipt. Has anybody got an workaround?

1 year ago

DogeMoonRocket

asked in Distribution

Ship more than the order, but update inventory accordingly?

Ill get straight to the point with an example. (Totally made up for simplistic purposes.) Somebody orders ten 6 packs of Peeps. They are $5. Order total $50.We charge them $50. But we are out of 6 packs, so at no extra charge, we send them ten 8 packs. We process the order as the 6 packs they ordered, But we want to keep the 6 packs at 0 in inventory, and deduct 10 from the 8 packs. Is there a simple way to handle this?

1 year ago

deebhaneSemi-Pro I

asked in Distribution

Transfer order default location

Is it possible to set a default warehouse only for transfer order?We knew their location configuration at the warehouse level. Looking to see if there is a way to set a default location only in case of transfer orders.

1 year ago

bernadeth58Jr Varsity III

asked in Distribution

Base Sales Price Entity Automation Schedule

Hi Everyone,Can I make an automation schedule for the Prepare and Process of Base Sales Price entity? I can’t find it in Automation Schedule screen in Acumatica.Thanks in advance.

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

MichaelhSemi-Pro II

asked in Distribution

Default Unit Price for 2-Step (Warehouse to Warehouse) Transfers

What field defines the default Unit Price for a STOCK ITEM on a 2-STEP Transfer? Doing international transfers and customs needs to know a value. It’s not a price worksheet (this is a warehouse, not a customer) and “Default Price” doesn’t seem to come over when making a new Sales Order of type TR.I can code around this (if price = 0, then get Default Price from Stock item), but if something already exists, I’d like to leverage that instead of attaching my Mickey Mouse code to the report. Thanks Everyone!

1 year ago

lorneweinsteinFreshman I

asked in Distribution

Acumatica Physical Inventory Module - how do you deal with having inventory frozen?

Hi Everyone. W are looking to enable the Acumatica physical inventory module in our company. It seems that the inventory selected to be counted will be locked in the system during the process and we typically count during our operating hours. I wonder how others have dealt with this issue. Any feedback or experience you may have with this module would be appreciated

1 year ago

krausef77Semi-Pro I

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?

1 year ago

FrancesPantelidakis24Jr Varsity II

asked in Distribution

Customer ships to multiple locations with same carrier but multiple accounts

We have multiple locations that we ship to for one customer, and this customer has three different UPS collect account numbers. How do we set that up in Acumatica so it works with EasyPost? Thanks,Frances Pantelidakis

1 year ago

abdulmuksithshahul61Freshman I

asked in Distribution

Purchase Requisition

Facing an error While creating a purchase requisition,can’t able to add creator but we hired employee . how to resolve it ?

1 year ago

cervantes09Freshman I

asked in Distribution

Material purchasing group or MRP controller

Hello to all, I have the pleasure of joining on with a company utilizing Acumatica*. We are very much in the beginning stages of setting up and creating part numbers with designated vendors and just like myself we are new to this process and system. My question here being, using Acumatica is there a way to register each individual part number a purchasing group or MRP controller much like SAP to better maintain material requirements.

1 year ago

jeans16Freshman II

asked in Distribution

Customer refund before product return

My client needs to be able to issue a refund to their customers before the product is received back in. We were trying to use an RC order type and on the general screen you can select a box to “allow refund before return”. Has anyone been able to get this to work. The prepare invoice selection is still grayed out and we can only get the credit memo issued once we complete the return. They need to track when the product is returned and it is serialized product but they want to issue the credit before the product is returned. If anyone has successfully setup this workflow can you let me know how you did it?Thanks,

1 year 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

Page 42 / 79

Badge winners

courtneybhas earned the badge Easy talker
nhatnghetinhhas earned the badge Low Code | No Code Customizations or Integrations
johnh3has earned the badge Easy talker
andriitkachenkohas earned the badge Configuration and installation expert
andriitkachenkohas earned the badge Integrations and Web Services | APIs expert