X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Code For New Trade Allocation Qty, Access 2007    
post Feb 26 2018, 09:42 PM

Posts: 3
Joined: 26-February 18

I have 1 customer with trade more than 1 item , like this
Attached File  tradedetail.JPG ( 29.9K )Number of downloads: 3

at the end of day, customer, want to split that transaction into several customer , from MI to MIa, Mib, MIc , with same avg price and amount ,only difference qty , like this
Attached File  tradeallocation.JPG ( 34.47K )Number of downloads: 2

and i should get a result report like this
Attached File  NewTD.JPG ( 37.34K )Number of downloads: 1

right now i got that report with manually using ms.excel solver ,after validating the average price ,amount and quantity

my question is , how to get automaticly with ms.access , can you give me a guide or maybe some code to solve this probrem

Go to the top of the page
post Feb 27 2018, 06:39 AM

UA Admin
Posts: 34,110
Joined: 20-June 02
From: Newcastle, WA

How do you determine the customers for the allocation? Are they always the same three customers? Or can the number vary? Or will it be different customers on different days?
Go to the top of the page
post Feb 27 2018, 09:02 PM

Posts: 3
Joined: 26-February 18

at below only for example ,

real process like this
1. main dealer will be transaction buy/sell stock item everyday ( item can vary )
2. at the end of day, I send Trade Detail ( excel ) by email to dealer
3. dealer will be split Trade Detail into several customer ( number can vary ) --Trade Allocation and dealer will be send email to me
4. I split manually trade detail into Trade Allocation one by one using solver ms.excel

thats i do everyday

note between Trade detail and after i split Trade detail allocation , will be difference amount can be tolerance ( -1 until 1) because using average price

Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    14th December 2018 - 10:32 AM