Page 2 of 2 < 1 2
Topic Options
#16111 - 02/24/09 09:00 PM Re: Actual Cost [Re: SusanTennier]
Bruce Gardner Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3504
Loc: Toronto ON, Canada
Hello Susan:

Actually you can reduce the Actual Cost without reducing the Quantity.

Look at the ICIADJ.xls file in the \Softrak\ICWIN\SAMDATA folder. To reduce just the cost, you would enter 0 for the "Stock Qty" column and a negative figure for the "Ext Cost" column. This results in a transaction where "Type" = "Cost decrease".

As suggested earlier, I would test this in Sample data first.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#16112 - 02/24/09 09:09 PM Re: Actual Cost [Re: Bruce Gardner]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
Great to hear this! Thanks. I will try it.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#16113 - 02/24/09 10:31 PM Re: Actual Cost [Re: SusanTennier]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
It worked like a charm. It was weird that it forced me to provide a location when there were no quantities involved, but it had no bearing on the end result. This import saved me from entering over 200 adjustments manually. Thanks again!
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
Page 2 of 2 < 1 2


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 60 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1848 Members
5 Forums
14242 Topics
69746 Posts

Max Online: 359 @ 11/18/19 09:08 PM
May
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31