Re: Ledger for inventory System

[Pete Keen]

> How granular accounts maybe? And could they be created and removed by the
system? Or in most of the cases they are a predefined static list? Any help
is much appreciated. Thanks!

You can make accounts as granular as you want. For example, in a system I'm
working on right now to reconcile Amazon purchases I'm going to have one
account per invoice. In another part of my personal system I have one
account per paper check or billpay that we issue, like this:

2020-07-13 * Landscapes Inc.
Expenses:Landscaping$100.00
Liabilities:Checks:Bank Name:Account Name:1056

2020-07-15 * Check paid
Liabilities:Checks:Bank Name:Account Name:1056  $100.00
Assets:Bank Name:Account Name

I don't believe there's a way in ledger-cli to delete accounts, but if they
have zero balance then they won't show up by default in balance reports.

On Wed, Jul 15, 2020 at 11:36 AM Kent R. Spillner  wrote:

> Perhaps something like this (those are tabs, '\t', in inventory.ledger):
>
> $ cat inventory.ledger
> 2020-07-01 * Initial inventory
> Inventory:OnHand:Bags:Pallet 7  55 bag
> Inventory:OnHand:Bags:Pallet 42 0 bag
> Inventory:OnHand:Bags:Initial Inventory
>
> 2020-07-15 * (order id#12345) Acme, Inc.
> Inventory:OnHand:Bags:Pallet 7  -1 bag
> Inventory:OnHand:Bags:Pallet 42  1 bag
>
> $ ledger -f inventory.ledger balance --no-total
>0  Inventory:OnHand:Bags
>  -55 bagInitial Inventory
>1 bagPallet 42
>   54 bagPallet 7
>
> -Original Message-
> From: "dmitrib...@gmail.com" 
> Sent: Wednesday, July 15, 2020 07:15
> To: "Ledger" 
> Subject: Ledger for inventory System
>
> Hi guys. I'm trying to apply ledger for an inventory system. The main
> question I'm struggling with is can I create a separate Account per pallet
> for example? Initially I thought my accounts would be OnCustomerSide,
> InTransit, OnHand, Reserved, Defected, Lost, Dispatched. Now I see that we
> have a functionality when you have 55 bags on pallet, and you can take 1
> bag from that pallet and move it to another pallet. That logic brings me
> to
> the idea that I could program each pallet as an account. Or am I wrong?
> How
> granular accounts maybe? And could they be created and removed by the
> system? Or in most of the cases they are a predefined static list? Any
> help
> is much appreciated. Thanks!
>
> --
>
> ---
> You received this message because you are subscribed to the Google Groups
> "Ledger" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to ledger-cli+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/ledger-cli/88b0368e-fa1c-48cd-8f6c-7459b2d6c351n%40googlegroups.com
> .
>
>
> --
>
> ---
> You received this message because you are subscribed to the Google Groups
> "Ledger" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to ledger-cli+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/ledger-cli/1594827398.10875870%40apps.rackspace.com
> .
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/CAFxm1Pn7ueyJZdO6qsrE9%3D3i3wAAsOgsTBOvC%3DKYj7mD%2B0Ntxw%40mail.gmail.com.

RE: Ledger for inventory System

[Kent R. Spillner]

Perhaps something like this (those are tabs, '\t', in inventory.ledger):

$ cat inventory.ledger 
2020-07-01 * Initial inventory
Inventory:OnHand:Bags:Pallet 7  55 bag
Inventory:OnHand:Bags:Pallet 42 0 bag
Inventory:OnHand:Bags:Initial Inventory

2020-07-15 * (order id#12345) Acme, Inc.
Inventory:OnHand:Bags:Pallet 7  -1 bag
Inventory:OnHand:Bags:Pallet 42  1 bag

$ ledger -f inventory.ledger balance --no-total
   0  Inventory:OnHand:Bags
 -55 bagInitial Inventory
   1 bagPallet 42
  54 bagPallet 7

-Original Message-
From: "dmitrib...@gmail.com" 
Sent: Wednesday, July 15, 2020 07:15
To: "Ledger" 
Subject: Ledger for inventory System

Hi guys. I'm trying to apply ledger for an inventory system. The main 
question I'm struggling with is can I create a separate Account per pallet 
for example? Initially I thought my accounts would be OnCustomerSide, 
InTransit, OnHand, Reserved, Defected, Lost, Dispatched. Now I see that we 
have a functionality when you have 55 bags on pallet, and you can take 1 
bag from that pallet and move it to another pallet. That logic brings me to 
the idea that I could program each pallet as an account. Or am I wrong? How 
granular accounts maybe? And could they be created and removed by the 
system? Or in most of the cases they are a predefined static list? Any help 
is much appreciated. Thanks!

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/88b0368e-fa1c-48cd-8f6c-7459b2d6c351n%40googlegroups.com.


-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/1594827398.10875870%40apps.rackspace.com.

Ledger for inventory System

[dmitrib...@gmail.com]

Hi guys. I'm trying to apply ledger for an inventory system. The main 
question I'm struggling with is can I create a separate Account per pallet 
for example? Initially I thought my accounts would be OnCustomerSide, 
InTransit, OnHand, Reserved, Defected, Lost, Dispatched. Now I see that we 
have a functionality when you have 55 bags on pallet, and you can take 1 
bag from that pallet and move it to another pallet. That logic brings me to 
the idea that I could program each pallet as an account. Or am I wrong? How 
granular accounts maybe? And could they be created and removed by the 
system? Or in most of the cases they are a predefined static list? Any help 
is much appreciated. Thanks!

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/88b0368e-fa1c-48cd-8f6c-7459b2d6c351n%40googlegroups.com.

Re: data formats for ledger convert

[o1bigtenor]

On Wed, Jul 15, 2020 at 1:09 AM John Wiegley  wrote:

> > "J" == Joel   writes:
>
> J> The ledger manual gives a bit of guidance for csv conversion of data
> J> formats.
>
> J> Can ledger convert handle dates such as this:  Aug. 05, 2016, 08:50 AM
>
> I think if you set --input-date-format correctly, you should be able to
> achieve this.
>
> You may wish to consider using the ISO date/time format  - - - - - your
example would look like   20160805T0850   .

I have adopted such as, for me at least, I no longer need to worry about
whether its month first or day first (its biggest values to smallest ones)
and the time is also a 24 hour clock and seconds and parts thereof can
also be added . For a higher volume sales center this would enable very
precise logging of sales where the time of sale could possibly even be
used as an identifier for said sale.

Regards

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/CAPpdf59SxAxMCksAdGFUGbkRnTWSbgOpYHV16sePg0ceEu2pGg%40mail.gmail.com.

Re: UUID based Filtering

[Martin Michlmayr]

* mail.ghanashyam.pra...@gmail.com  
[2020-07-14 10:42]:
> I'd like to therefore double check at any time, I had same UUID used
> more than twice. Does ledger allow for reporting transactions based
> on UUID filtering? 

How about some shell commands?

grep "; *UUID:" *.ledger | sort | uniq -c | sed -e "s/^ *//" | cut -d" " -f1 | 
grep -v "^\(1\|2\)$"

-- 
Martin Michlmayr
https://www.cyrius.com/

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/20200715102548.GD7200%40jirafa.cyrius.com.

UUID based Filtering

[mail . ghanashyam . prabhu]

Hello, 

I started to use ledger recently for tracking finances and the primary 
inputs 
my ledger is my checking account and credit card statement. Using a 
rudimentary 
python script, I parse out these statements to populate the ledger. 

For credit card bill payment transactions, I have duplicate transactions 
and I use 
UUID metadata to drop of them. My script uses a UUID format of 
: 
while parsing the statement. 

See suggestion here from reddit Dealing with Duplicate Transactions 

 
I'd like to therefore double check at any time, I had same UUID used more 
than 
twice. Does ledger allow for reporting transactions based on UUID 
filtering? 

Any other options to make sure UUIDs are not duplicate for more than one 
pair 
of transactions?

An example of the transactions that I am talking about

2020/01/09 * BANK OF AMERICA CREDIT CARD Bill Payment
> ; bofacc
> ; UUID: 2020.01.09-cc-ma:bofa
> Liabilities:cc-ma:bofa $563.85
> Assets:checking:bofa
>
> 2019/01/09 * PAYMENT - THANK YOU
> ; payment to CC
> ; UUID: 2020.01.09:cc-ma:bofa
> Liabilities:cc-ma:bofa $-$563.85
> Assets:checking:bofa

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/639d1c41-e35e-4475-a50c-0625064a127ao%40googlegroups.com.

Re: data formats for ledger convert

[John Wiegley]

> "J" == Joel   writes:

J> The ledger manual gives a bit of guidance for csv conversion of data
J> formats.

J> Can ledger convert handle dates such as this:  Aug. 05, 2016, 08:50 AM

I think if you set --input-date-format correctly, you should be able to
achieve this.

John

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to ledger-cli+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/m2365txqad.fsf%40newartisans.com.