hey everyone i have a question when i sync the FBA...
# generall
linavokolans
03/14/2023, 7:59 PMhey everyone i have a question when i sync the FBA from Amazon to NS using integration it creating an invoice in NS will that allocate the items will it reduce the inventory or not?
p
Pete Kastner
03/14/2023, 8:06 PMYes, a Stand alone invoice with no sales order will reduce inventory. That is how Celigo with Amazon FBA works.
l
linavokolans
03/14/2023, 8:34 PMThank you so much @Pete Kastner
linavokolans
03/15/2023, 1:22 AM@Pete Kastner Yes now the issue is under G/L impact i don't see the inventory account only A/R account
a
AK47
03/15/2023, 1:07 PM@linavokolans depends what items are on your invoice. IF there are inventory items, then it would deduct inventory. If your invoice doesn't include inventory items...then it won't.
l
linavokolans
03/15/2023, 1:11 PMit have inventory items
linavokolans
03/15/2023, 1:11 PM@AK47
a
AK47
03/15/2023, 1:20 PMShare your invoice and the GL impact? As @Pete Kastner said, if it's a stand alone invoice with no sales order that has inventory items, then your GL impact will hit the inventory asset account.
l
linavokolans
03/15/2023, 1:43 PM@AK47 i only sync Invoice becasue we only sync FBA Orders, no Sales Order
and items are inventory items
Thank you
a
AK47
03/15/2023, 2:11 PMOn the invoice, what does it say in created from? This appears to be an invoice from a sales order.
l
linavokolans
03/15/2023, 2:41 PM@AK47 nothing it a standalone invoice (FBA)
a
AK47
03/15/2023, 3:09 PMah....ok, what is the valuation of the items sold? I assume its $0. If there are inventory items with value sold on a standalone invoice, it will absolutely hit the inventory asset account. But if the value of the item in that location on that date is nothing, then nothin happens
l
linavokolans
03/15/2023, 3:30 PMAhhh okay how can i check that valuation of the items sold
linavokolans
03/15/2023, 3:30 PM@AK47 Thanks in advance
linavokolans
03/15/2023, 3:46 PM@AK47
Item A:
• Quantity: 1
• Average Cost: 1.00
• Valuation: 1 (Quantity) * 1.00 (Average Cost) = $1.00
Item B:
• Quantity: 1
• Average Cost: 0.00
• Valuation: 1 (Quantity) * 0.00 (Average Cost) = $0.00
Total valuation for the items sold in the invoice: $1.00 (Item A) + $0.00 (Item B) = $1.00
r
Ricky
03/15/2023, 7:55 PMI prefer to have the sales orders come into NetSuite
Then these can be automatically fulfilled with a workflow or script
Then invoices can be created via billing operations
I don’t like just to being in standalone invoice
l
linavokolans
03/15/2023, 8:59 PM@Ricky Yeah but becasue it an automation FBA from Amazon it generate invoice instead of SO
r
Ricky
03/15/2023, 9:31 PMWhich connector are you using to do this?
l
linavokolans
03/15/2023, 9:41 PMCeligo @Ricky
r
Ricky
03/15/2023, 10:02 PMCeligo can post sales orders instead of invoices
I have done this with another client
It’s just a config change
l
linavokolans
03/15/2023, 10:11 PMAhhhh i see Thank you so much @Ricky
2 Views