Community
Discussion Forums
Distribution

Distribution

Inventory, Orders Management, Warehouse Operations

2,019 Topics
7,574 Replies

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

2019 Topics

Recently active

Most replies Most views Newest first

dougmcbride79Semi-Pro I

asked in Distribution

Business Event with Product Images

We want to create a report with item mages and send the report via a busines event. The report would have a customer’s prior item purchases with the each item’s image from the item’s “attributes”. Is there a way in the same report to have an item’s description, the item’s purchase history, and the the item’s image from item attributes in the same report?

10 months ago

K2aJr Varsity III

asked in Distribution

Unshipped Amount Calculation

Hey Folks, wondering if anyone has had any challenges with some of the “TOTALS” metrics on the SO. We are looking to understand how the Unshipped Amount is calculated on a SO because it does not match the formula presented:The formula per the HELP icon is:The sum of unshipped amounts calculated for the lines with nonzero unshipped quantities of stock items. The unshipped amount for each line is calculated as the amount in the Ext. Price column (after Line-level discounts were applied) divided by the line quantity (the Qty. column) and multiplied by the unshipped quantity (the Open Qty. column). At the moment of order creation when no item quantities are shipped, the amount is equal to the Line Total; this total does not include any freight amount. This box appears only if the Inventory feature is enabled on the Enable/Disable Features form.Metrics:As you can see the Unshipped Amount = 7,336.54 If you review the lines for the particular SO in question we see:It seems like the Unshipped

10 months ago

ranjithd46Freshman I

asked in Distribution

Is Acumatica storing last Sales Order created date for a Customer?

10 months ago

ReddyFreshman I

asked in Distribution

When i am trying to create a sales order, the following error has occurred. Error: " The account is on a credit hold. Remove from credit hold?"

Error: “The account is on a credit hold. Remove from credit hold?” When I am creating a new sales order, the following error has occurred.

10 months ago

abrilromero06Freshman I

asked in Distribution

AP Line Attachments in Vendor Details

Hi Everyone Is there a way to see the document LINE attachments in the Vendor Details Screen (AP402000) without opening the actual document? Thanks

10 months ago

FrancesPantelidakis24Jr Varsity II

asked in Distribution

Fixed Asset Import

Hi,I have already imported the basic fixed asset information. We are doing a FA implementation and the system is in migration mode. However, I am trying to do a second import only to update the Last Depr Period and Accum. Depr (see below) and my import is failing. The second screenshot is my import scenario. I have also attached a copy of my data provider. What fields am I missing in my import scenario or Data Provider. Thank you,Frances

10 months ago

Fie

asked in Distribution

Same Location in Warehouse

Hi, Upon adding the same location in warehouses, upon saving the added location does it disappear?We want to tag a different project task in one location to process a transaction with project ID tagging.Thanks!

10 months ago

K2aJr Varsity III

asked in Distribution

unbilled balance/unshipped amount

Hey folks,Looking to get some information for our Data Warehouse and came across a funky little calculation discrepancy that we can’t seem to figure out. If you look at the SO Totals page in this example and you read the documentation it doesn’t seem that Unbilled Balance and Unshipped Amount are correct. And can’t really figure out how these are calculated… Also not sure how Order Level Discounts are factored in here, but any insight would be helpful. We are trying to siphon out the unbilled/unshipped amounts for reporting and they do not match the SO values…

10 months ago

MichaelhSemi-Pro II

asked in Distribution

AcuPayments Integrations

Can AcuPayments be used with: WooCommerce, Big Commerce, and Shopify?If so, which behaviour should I be expecting? I’m assuming it’s #1.Authorize and Capture on the website Sales order and captured Payment transmitted to Acumatica Authorize on website – Capture in Acumatica before shipment. Sales order and Authorization payment transmitted to Acumatica. I’m also open to a link to documentation about AcuPayments, but my quick searching is not returning anythng menaingful regarding who it can be used with and how it will be used. Thanks!

11 months ago

CodyKFreshman II

asked in Distribution

Backing Out/Deleting a Purchase Receipt?

Once we create a purchase receipt and release it, the only way I find to “back it out” is via a return. Is there a way to delete a purchase receipt or is doing a return the only way? Thank you in advance!

11 months ago

kmaharaj

asked in Distribution

Purchase Order No Ship Date

There is no ‘ship date’ field in the Purchase Order.When submitting PO to vendor how do they know when the desired (RSD) requested ship date is? There is Promise date but that date is when we expect to receive the goods from the vendor and we don’t want to include that on the PO for fear of them using that as their ship date.Coming from SAP and Oracle worlds, I’m surprised there is no ship date on a PO and am curious what the community is doing over come this issue. Look forward to feedback. Thanks.

11 months ago

TBuschFreshman I

asked in Distribution

Inventory Labels by warehouse locations

Is there a way to print labels containing the item # and description sorted by warehouse location? Storage summary seems like it would work but there’s no option to export to a label printer. Any tips would be appreciated.

11 months ago

scottaisd00Freshman I

asked in Distribution

Replenishment. Quantity Replaned.

In the Replenishment process, what does Replaned mean? How does Replaned affect the Create Purchase Order process?

11 months ago

scottaisd00Freshman I

asked in Distribution

Replenishment. Items on Sales Orders. Items without Replenishment settings but in Item Class that has Replenishment settings.

We have Items without Replenishment settings but that are in an Item Class that has Replenishment settings. When these items are on a Sales Order, we would like to capture them in the Replenishment process. We don’t like to use Mark for PO because then our Sales Reps need to know which items have Replenishment settings and which items need to be Marked for PO.Is there a way for the Replenishment process to catch items on Sales Orders that have no Replenishment settings?

11 months ago

BigKev

asked in Distribution

How do i add a reference to a products carton qty and carton barcode information?

Hey Acumatica Community. Im hoping someone is able to point me in the right direction here and that its not something that needs an external plugin…..The scenario is i have a product that sells as each's but comes in a carton of 10. The carton has a different barcode to the product itself and i want to scan the carton barcode when paperless picking and for it to register as 10x units of the actual product. Can someone please explain what section of Acumatica i would go to set this up?Appreciate any help given.

11 months ago

andy99Freshman I

asked in Distribution

box stock item added to shipment

Does anyone know a way to add a box that is a stock item to a shipment without adding it to the sales order? the Boxes tab looks like it does not have that option. Thanks.

11 months ago

donnadeskins55Varsity I

asked in Distribution

Configure a product on a blanket SO

Is it possible to configure an item on a blanket sales order?I have a customer who uses the Product Configurator to configure items on sales orders. They are exploring using blanket sales orders, but it doesn’t look like configuring is possible on a blanket SO type.

11 months ago

BenFoyFreshman I

asked in Distribution

Purchase Orders line item status

Would I be correct in thinking that the purchase order line item status completes when received and closes when their corresponding bill is paid?

11 months ago

Ramos5522Freshman II

asked in Distribution

Two shipments and one SO simultaneously

Hello everyone My company requires to open several shipments that have several lines (products) of one SO. Acumatica doesn’t allow you to have an open (unconfirmed) shipment add modify the sale order simultaneously. I need to create multiple open shipments at the same time. If you create one shipment it lock the SO and doesn’t allow you to create additional shipments without confirming them. Does anyone know how to unlock the SO?

11 months ago

Sai ChettiarFreshman II

asked in Distribution

Sales Prices with Template Item

We have a scenario on hand. Assume that we have a Template Item SKU as Parent001 with three combination SKUs as follows: Child001Child002Child003Each of these products is being sold at a base price of $20Next let us say on the Sales Prices screen we have defined a quantity break of 5 and a price of $16. On the Sales Order, if we add Child001 with the quantity as 10, then the price reflects as expected to show it as $16 each. Our customer has a requirement that if someone buys 3 qty of Child001 and another 3 qty of Child002, thus exceeding the break qty of 5 defined at the Template parent level, the Sales Prices should kick in since the discounted break qty price is based defined at the parent level. Any thoughts here to achieve without a customization? Thanks in advance !!!

11 months ago

ranjithd46Freshman I

asked in Distribution

We are having an Issue with a Table "InItemSiteHist" and a filed in Warehouse screen "Include in Qty Available".

The customer has created one GI that stopped displaying the data of adjustment Qty “tranPtdQtyAdjusted” after disabling this field Include in Qty Available in the warehouse screen. Does this field have any relation to Table "InItemSiteHist" of storing issue and Adjustment qty?

11 months ago

bbdragonflyFreshman I

posted in Distribution

How to correct Inventory qty that has been debited to a wrong warehouse

Hi everyone,I made a bulk import of Sales Order and realized that there are items that has been charged to incorrect warehouses. Those SO are already have a complete status. What is the best way to correct this? Is it through receipt/issue or adjustment?

11 months ago

mdmorgan85Freshman III

asked in Distribution

Can't release Move due to WO being closed... by move

So it looks like move completed the WO, and then an employee closed the WO before the move was released. What should i do here… Error below: The WO WO128702 production order with the Closed status cannot be used in this process.

11 months ago

pcraske31Freshman I

asked in Distribution

1 Shipment - 3 invoices

Hi there,I have a scenario where I need to invoice one shipment on three different invoices, as our sales rep has agreed that the customer can pay over three months.Is this possible, rather than just creating one invoice and telling the customer to pay in equal instalments over three months

11 months ago

BOSullivanFreshman I

asked in Distribution

Rotating a either ajpg or png file image

Is there a way to rotate an image in stock items screen also known as ID CST.IN.20.25PL?

11 months ago

Page 32 / 81

Badge winners

jhoncandare04has earned the badge Easy talker
suchit39has earned the badge Easy talker
Dmitrii Naumovhas earned the badge Product guru
swittrockhas earned the badge Easy talker
jzhuhas earned the badge Easy talker

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Social Login

Login to the community

Social Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.