Update price unit in manage cost (Released Product)

(0) Share

Report

Posted on by Community Member

hi,

i need to update the price unit for all the items to zero and i need a help to run a query to update for all items because it will be difficult to update the price one by one.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

sorry not the unit price what i need to update the price to be zero

Was this reply helpful? Yes No
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

Hi!

You should update Amount field in PriceDiscTable and PriceDiscAdmTrans tables.

After update call the PriceDisc::flushPriceDiscCache() method.

You should run update data in every entity.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

as far i know the table name is InventTableModule , ModuleType : inventory and Price, so i need to run and query to update all prices to zero

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

but how can i run one job to update the price for all items to zero?

Was this reply helpful? Yes No
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!
My suggestion was for price agreements, sorry.

If you want update Price field in InventTableModule table for all items, try this:

static void Job174(Args _args) { InventTableModule inventTableModule; ttsBegin; update_recordSet inventTableModule setting Price = 0 where inventTableModule.ModuleType == ModuleInventPurchSales::Sales; ttsCommit; info("done"); }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

thanks a your quick update but if I need to update the inventory only it should be ModuleInventPurchSales::Inventory; ?

Was this reply helpful? Yes No
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

Yes.

Was this reply helpful? Yes No